Home > database >  How to roll back the alter operation
How to roll back the alter operation

Time:09-24

I was hoping to modify the tablespace file path,
Perform the
The alter database rename file 'original path \ file' to 'new path \ file';
Because involves many table space, lead to a lot of, don't go up now, seeks to solve

CodePudding user response:

With backup path, before or after your data file copy to rename

CodePudding user response:

The table space data file to restore to its original position, take a look at this line not line

CodePudding user response:

Use CTRL + E see your statement history then before recovery path can not be in C before you ALTER a D that you now can't ALTER C again? I didn't try just tell me if I can give you some ideas that is better for don't blame me, oh

CodePudding user response:

V $datafile, the location of the records in the file, can see the actual location which files didn't agree with this view, adjust the back,
  • Related