Has anyone ever tried to edit the DMP file produced by the Oracle EXP utility?
I noticed that the dump file contains the name of the tablespace of the original set of tables. Oracle will IMP the tables into the same tablespace name on the new server. If I want to IMP into another server which has a different tablespace name, I thought I might be able to edit the "TABLESPACE <name here>" clause in the dump file. Wrong! The error message says that the "character set marker is unknown". What's that all about?
Any advice, guys? Maybe there is an easier way to IMP and change the tablespace name at the same time?
I noticed that the dump file contains the name of the tablespace of the original set of tables. Oracle will IMP the tables into the same tablespace name on the new server. If I want to IMP into another server which has a different tablespace name, I thought I might be able to edit the "TABLESPACE <name here>" clause in the dump file. Wrong! The error message says that the "character set marker is unknown". What's that all about?
Any advice, guys? Maybe there is an easier way to IMP and change the tablespace name at the same time?