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

Home -> Community -> Usenet -> c.d.o.server -> Re: Export / IMPORT on Oracle 7

Re: Export / IMPORT on Oracle 7

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Sat, 11 Jan 2003 16:27:47 +0100
Message-ID: <ltd02vcsq6d2am6jpcn36dai02qiuefge5@4ax.com>


On Sat, 11 Jan 2003 07:39:55 -0500, Lorraine Lachoade <Lorraine_lachoade_at_hotmail.com> wrote:

>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!

imp help=y will show you
imp <username/password> file=... full=y commit=y ignore=y buffer=<at least 8M in bytes> log=....

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jan 11 2003 - 09:27:47 CST

Original text of this message

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