Home » SQL & PL/SQL » SQL & PL/SQL » Backing up tables
Backing up tables [message #21414] Thu, 01 August 2002 20:23 Go to next message
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 Go to previous message
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
Previous Topic: 1Z0-101 Certification Exam
Next Topic: datatype help
Goto Forum:
  


Current Time: Fri Apr 26 13:22:46 CDT 2024