Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle - import of dmp-files change the table name

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

From: Mark Bole <makbo_at_pacbell.net>
Date: Sun, 12 Sep 2004 14:23:40 GMT
Message-ID: <MZY0d.18661$Jd1.17317@newssvr27.news.prodigy.com>


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
[...]
> Because there is new data coming to the system I am not able to use
> the table the dmp-file was created from.
[...]
> 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 .
>

[...]
> Greetings
> Matthias

The other advice posted is fine as far as it goes, but I see a much bigger problem here if I infer correctly that this is a production system.

Be assured that it is indeed possible to "stop the database" -- maybe not in a way that you planned. How can it be that you only have one database available? Use a test database, create it on the same server if you must or put it on your workstation using Personal Edition.

If you have "too many dependencies nobody knows", it is inevitable that you will break something or make a mistake that you can't easily recover from.

If the database is too big to clone a complete copy for test purposes, then just import your one table into a new database and use a dblink to have access to all the tables you need concurrently.

As a side note, if you have a "set" of dmp files that only contain one table, this would mean the export used the FILESIZE option to split the output files, and I'm pretty sure you can't re-import only some of them.

--Mark Bole Received on Sun Sep 12 2004 - 09:23:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US