OraFAQ Forum: Server Utilities » how to take export users

Home » RDBMS Server » Server Utilities » how to take export users

Fri, 30 September 2005 06:23

c_gajen
Messages: 8
Registered: September 2005
Location: Nagpur

Junior Member

hello ,
i am using 9i i want to exp users wtih there contents
please give me steps.
thanks .

Fri, 30 September 2005 07:14

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

 
 exp userA/passwd file=file_name.dmp log=file_name.log 

 imp system/passwd file=file_name.dmp fromuser=userA touser=userB

Read this document

and then post your doubts.

[Updated on: Fri, 30 September 2005 07:16]

Previous Topic:	Importing data from .csv file
Next Topic:	SQL*Load with concatenation

Goto Forum:

]

Current Time: Sat Nov 09 01:49:40 CST 2024