import

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

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

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]

The manual can be found at http://otn.oracle.com/docs/products/...ch02.htm#42458