Home » RDBMS Server » Server Utilities » Backup table
Backup table [message #72788] Mon, 20 October 2003 12:23 Go to next message
pg
Messages: 12
Registered: May 2002
Junior Member
I have to do the backup on DAT of data a table. I need to know the script.
Can you help me?
Re: Backup table [message #72790 is a reply to message #72788] Mon, 20 October 2003 14:27 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Export the table using exp ..like

exp user/pass file=table.dmp tables=owner.table compress=n consistent=y grants=y feedback=1000 log=table.log

and then copy the dump file to your DAT..
Previous Topic: to send an email
Next Topic: sqlldr question
Goto Forum:
  


Current Time: Wed Jun 26 12:47:58 CDT 2024