| Database Export [message #73045] |
Thu, 22 January 2004 19:22  |
Vinnie Dubonnet
Messages: 1
Registered: January 2004
|
Junior Member |
|
|
Can someone tell me what is the command for doing a full export of a 9i datadase onto a remote server and also explain how it should be done? (ie creating an empty Database on the destination server) I'm a new DBA and this matter is urgent.
Thanks
Vinnie
|
|
|
|
| Re: Database Export [message #73048 is a reply to message #73045] |
Fri, 23 January 2004 02:42  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
#in source machine
exp dbause/password file=somefile.dmp log=somelog.log full=y
#this will create a dmp file. DONT EDIT it at any cost.
#create the target database, with same users,tablespaces etc.
#you can ftp the file to remote server. make sure u do the ftp with bin option.
#you CAN IMPORT THE DATABASE AS A WHOLE. But I always recomend to import USER-BY-USER.
#in target machine
imp dbauser/password file=somefile.dmp fromuser=sourceuser1 touser=targetuser1
# SECOND METHOD is you no need to do the ftp.
# create a tnsConnectstring to talk to other database in other machine. and use it in import
# say if the connecstring is targetdb
imp dbauser/password@targetdb file=somefile.dmp fromuser=sourceuser1 touser=targetuser1
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
