How to import, export from Ora (using SQL plus or DBA)?

[Guest_imported]

How to import, export from Ora using SQL plus (command line) or DBA? I have done but I failed. Give me more details how to do, please.
Thanks.

 

[sunpatil]

you have to use host command from sql if u want to do exp-imp. there is a limitation for this.

U can only do this from oracle server m/c.(i.e if u r doing from sql prompt.)
U should also check the user rights for exp-imp.

 

[Guest_imported]

What version of ORACLE ? If it's 8i, try this from the command line:

TO EXPORT:
oracle\ora81\bin\exp system/password@database OWNER = exported_user FILE = filename.dmp LOG = exp_filename.log

TO IMPORT:
oracle\ora81\bin\imp system/password@database FROMUSER = exported_user TOUSER = user_you_want_to_import FILE=filename.dmp LOG = imp_filename.log

You have to provide the right password for "system" account and the right database (or service)

You can also use another account (user or schema) if the objects belong to it:

oracle\ora81\bin\imp specific_user/password@database

"exported_user" is the user or schema you want to export (and re-import) of course. "filename" is whatever you choose to put as a file name.

I've used these commands several times with both Unix and Windows NT and they work fine, if you have the permission to use them (I mean, the user/password as "system/password&quot or course. For Windows NT I used them on my PC connected to the network (i.e I didn't have to do it using the ORACLE server).

smg