My small white one; More than 9 o 'clock in the evening on double tenth of a day; On the customer's server ready to create test library; Then don't know what a great god changed my TNS; Then lead to my guide DMP data into the officially on the library; Then the formal library data double; Excuse me the great spirit of all stripes; According to the timestamp restore the entire database?

CodePudding user response:

Step earlier may use flashback queries, of course, if you opened a flashback database (off by default), you can select the whole library flashbacks, but affects the whole library, need your own assessment is not appropriate, right
Can do now is to directly write SQL to heavy, but repeated fields need you choose according to the business is good, if you have a backup, you can choose to not fully recover, also can choose the whole library,

CodePudding user response:

Not for 24 hours; I saw a flashback is possible; But I have not used; Because it is new to the library (11th) to take over the day night guide library; To be unfamiliar with the library; I mean in the test library; Then don't know which changed my colleagues in the test library server TNS; Cause I want to guide test library data; Lead a formal library; Because of large amount of data; A bad a screening of the wound; If the flashback database (off by default); I saw is closed; Can't use is flash back to the library?

CodePudding user response:

Expdp default is will skip, I think you may use the exp, the general table has a primary key also complains, I estimate the impact of table is not much, for it is ok to certain tables to heavy, this situation is better than data is deleted!

CodePudding user response:

Have not cut into the primary key; There is no primary key data table into a double; Has been in accordance with the guide of library journal a a deleted; Thank you!