Oracle - import of dmp-files change the table name
Date: 8 Sep 2004 07:30:40 -0700
[Quoted] [Quoted] I have a problem importing a dmp-file back to the database.
[Quoted] I have only one database available and have a set of dmp-files with
backuped data (only one table in the file). To make some research on
the data I have to reimport some of the backup files to the database
and add some data from other tables (the actual data and the one in
the backupped which is not yet sored in a dmp-file).
[Quoted] Because there is new data coming to the system I am not able to use
the table the dmp-file was created from. So I want to import the data
to another table for example:
The table DATAARCHIVE was exported to a dmp-file. I need data from the actual table DATAARCHIVE and the table DATA. I want to restore the dmp-file to the table DATASEARCH so that I can add the information from the other tables without "NULL in column xyz is not allowed" or making the data in TFPLARCHIVE inconsistent or rebackup the data with the next creation of a dmp-file (which I don't control).
[Quoted] The environment is too large and with too many dependecies nobody knows, so I am not allowed to change the structure of the database or a table or removing Indexes. It is also not possible to stop the database. It's an Oracle 8.1.7 .
Is there a solution? I tried to rename the table name in the dmp-file but after that I got errors while importing (header not valid or problems with the character set). I read the oracle documentation for "import" but I was not able to find a possibility to choose another table name (maybe I am just blind).
Thanks a lot in advance.
Matthias Received on Wed Sep 08 2004 - 16:30:40 CEST