Re: Please send me an Import-Exmple ...now

On Wed, 01 Oct 1997 22:41:27 +0200, "Nett, Edmund" <enett_at_netcologne.de> wrote:

>hi,
>i have to import a 850MB dmp-file this night...but i'm sitting here
>at home with an isdn-connection to the server and no import-doc.
>So i don't know the syntax for the import with control-file.
>Please help me with an example.
>
> thanks, Eddy

Eddy,

This is from Oracle 7.3 doc set....

Command Line Method

imp adams/ez4me file=scott.dmp tables="(emp,dept)"

Interactive Method

imp adams/ez4me

...

Import file: expdat.dmp > scott.dmp

Enter insert buffer size (minimum is 4096) 30720>

Export file created by EXPORT:V07.01.03

Warning: the objects were exported by SCOTT, not by you

List contents of import file only (yes/no): no >

Ignore create error due to object existence (yes/no): yes >

Import grants (yes/no): yes > n

Import table data (yes/no): yes >

Import entire export file (yes/no): yes > n

Username: scott

Enter table names. Null list means all tables for user

Enter table name or . if done: emp

Enter table name or . if done: dept

Enter table name or . if done: . Received on Thu Oct 02 1997 - 00:00:00 CDT