I have live version of a DB that is distributed on 3 files on the filesystem.i.e. usr1.dbf,usr2.dbf and usr3.dbf. I know that there are tables that are split across the 3. Now the test version of the same DB has one file usrtest.dbf. I want to merge the 3 and then copy the file to the test one. Possible? If so, how? Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Merge dbf files
- Thread starter new2ora
- Start date
You cannot merge datafiles. However, you could export everything contained in that tablespace, drop all of the object within the tablespace, drop two of the files, and (assuming the third is large enough to hold everything) import the objects back in.
As for copying the file to another database - no, I don't think so. But you could use the same export dump file from above to import all of the objects to the other database.
As for copying the file to another database - no, I don't think so. But you could use the same export dump file from above to import all of the objects to the other database.
- Status
Similar threads
- Locked
- Question