Re: Oracle - import of dmp-files change the table name

Matthias Maschke wrote:
> Hi!
>
> I have a problem importing a dmp-file back to the database.
> 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).
> 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).
>
> 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.
>
> Greetings
> Matthias

If i read correcty between the lines you don't need the data from an exact date, so you could create a copy of the table using

create table xyz as select * from orig_table

then create the indexes you need on the new table, if you use cost based optimizer donøt forget to analyze the table.

best regards

Thomas Jensen Received on Wed Sep 08 2004 - 21:12:26 CEST