Re: Export / IMPORT on Oracle 7

On Sat, 11 Jan 2003 16:27:47 +0100, Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote:

>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

After I install Oracle 7 server, how do I first create the tablespaces?

I assume once I have the tablespace created, I only then need to create the same user name / password as on the source server so that I can import. Received on Sat Jan 11 2003 - 09:38:07 CST