Re: Export / IMPORT on Oracle 7

From: CajunDBA <cajundba_at_bellsouth.net>
Date: Sun, 12 Jan 2003 00:02:56 -0600
Message-ID: <U68U9.8085$Jm2.3220@news.bellsouth.net>

From your post, it appears to me you only want 1 table from the full export. Is that the case?

If so, it would be MUCH simpler than importing the entire full/complete export to a new Oracle 7 server.

For 1 table, you could simply import the 1 table from the full export into a different user on the production database. You could even use the same tablespace.

"Lorraine Lachoade" <Lorraine_lachoade_at_hotmail.com> wrote in message news:b0402vgfbtg004014evb00f4ef9kqb5hob_at_4ax.com...
> I have an Oracle 7 system and each night we do a complete export of
> the system to a .dmp file.
>
> What I want to do is take one of the .dmp files from a few months ago
> and put it on a newly installed Oracle 7 server as I want to get a
> data in a table that is no longer up to date on my production server.
>
> Can anyone step me through the process to IMPORT the .dmp file into my
> new Oracle 7 server?
>
> Thx in advance!
>
Received on Sun Jan 12 2003 - 00:02:56 CST