Oracle database in the normal use of libraries, insert the table data (the data is very important to delete), do the wrong operation, after changed the table structure and view storage, cause there is something wrong with the database, resulting in a specific don't know what to do the operation, after doing the backup, a backup is inserted into the existing data to do before, table structure and views are no problem, how to repair the database? And the need to ensure the integrity of the data, (I small white)

CodePudding user response:

Explain your best, what kind of backup,


If is rman, now do recovery test machine, and then through the dblink plug the data line,

If is exp or expdp, directly back to another schema (user), inserted again come,

CodePudding user response:

Yes, depends on the way you backup recovery way,
If you are a single table backup:
The create table newtable as select * from your table - now has a new backup data first watch
Drop table purge your watch;
The create table your table as select * from a backup before insert table;

If it is exp or expdp export backup:
To backup the existing structure and content, you have appeared to be
Drop table purge your watch;
Imp...

CodePudding user response:

reference 1st floor selling fruit net reply:

best explain the building Lord, is what kind of backup,


If is rman, now do recovery test machine, and then through the dblink plug the data line,

If is exp or expdp, directly back to another schema (user), inserted again come,

Backup with exp export, all operations with the same user,

CodePudding user response:

refer to the second floor jdsnhan response:

yes, depends on the way you backup recovery way,
If you are a single table backup:
The create table newtable as select * from your table - now has a new backup data first watch
Drop table purge your watch;
The create table your table as select * from a backup before insert table;

If it is exp or expdp export backup:
To backup the existing structure and content, you have appeared to be
Drop table purge your watch;
Imp...

Exp backup data, thank you for your guidance,

CodePudding user response:

reference 4 floor swj5013 response:

Quote: refer to the second floor jdsnhan response:

yes, depends on the way you backup recovery way,
If you are a single table backup:
The create table newtable as select * from your table - now has a new backup data first watch
Drop table purge your watch;
The create table your table as select * from a backup before insert table;

If it is exp or expdp export backup:
To backup the existing structure and content, you have appeared to be
Drop table purge your watch;
Imp...

Exp backup data, thank you for your guidance,

On another machine to install the same version of the database, then use your EXP backup files in IMP import, export and table removed and rebuilt, the problem of the original library data through DBLINK inserted into the original library

CodePudding user response:

reference swj5013 reply: 3/f

backup with exp export, all operations with the same user,

The imp to another user (it is best to create a new user),

To insert into t select * from new_user. T

CodePudding user response:

Define the table IMP, and then modify the source library table definition of what's the problem?

CodePudding user response:

refer to 7th floor sych888 response:

define table IMP, and then modify the source library table definition of what's the problem?

Which is 80 g database couldn't check the table, or which a few tables have problems thank you for your advice, thank you.

CodePudding user response:

Your information is too little, don't know your field current situation, the bad give out advice:
If you need to restore, or emergency recovery, can directly call us: 13429648788