import

[ashchopra]

how can i import a database..
if I don't want to use oracle management server..
I am using oracel 8.1.7 on W2000 professional edition..
is there is a way to import the database from command line...
can anybody give me steps for that.
thanks
..ash

[santoshym]

Hi Ash

Follow these steps

1) Goto command prompt

2) execute the following command

c:\> exp system/password@connectstring file=full.dmp log=full.log full=y consistent=y compress=y

The above command will create a binary dump of the full database

If you need to look at option available with exp you can do the following

1) Goto command prompt

2) Type the following

c:\> exp -help

If you still have any doubt let me know

Regards

[kris109]

For import, follow the same guidelines santoshym mentioned. You need a .dmp file from a database export. The basic command is:

imp user/pass@sid file=exp.dmp log=imp.log

Other most used parameters are:

commit=y will commit after each table

full=y will import the full export
or
fromuser= schema owner in the export file
touser=schema owner created in your for database for import

you can import selected tables too. rows= Y or N will or will not import the table data.

[Edited by kris109 on 08-15-2001 at 06:43 PM]

[marist89]

The manual can be found at http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76955/ch02.htm#42458