Backing up tables [message #21414] |
Thu, 01 August 2002 20:23 |
Chandan Singh
Messages: 14 Registered: July 2002
|
Junior Member |
|
|
Is there any way that i can take back up of tables created in scott/tiger user.Can i store it on floppies.
Please help
Thanks in Advance.
|
|
|
Re: Backing up tables [message #21419 is a reply to message #21414] |
Fri, 02 August 2002 04:33 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
just export in user mode. you can import it whereever you want.
if you are looking for the tables created by oracle ( for demo) like the EMP,DEPT etc,
you can create them anytime you want by running the script available at $ORACLE_HOME/rdbms/admin/scott.sql
|
|
|