Home » SQL & PL/SQL » SQL & PL/SQL » demo tables(emp,dept) recovery in scott
demo tables(emp,dept) recovery in scott [message #256080] Thu, 02 August 2007 23:21 Go to next message
sravanthireddychada
Messages: 6
Registered: July 2007
Location: india
Junior Member
how to get original table data after making changes on the tables emp & dept etc.pls let me know the command which is used to get original data while using scott user.
Re: demo tables(emp,dept) recovery in scott [message #256085 is a reply to message #256080] Fri, 03 August 2007 00:13 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
Restore from your backups.
Re: demo tables(emp,dept) recovery in scott [message #256094 is a reply to message #256080] Fri, 03 August 2007 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on your version and in which case you are but as you didn't tell us we can just give you the common solution: restore (as Ana said).
Another way is to replay the scott.sql script.

Regards
Michel
Re: demo tables(emp,dept) recovery in scott [message #256393 is a reply to message #256094] Sat, 04 August 2007 03:58 Go to previous messageGo to next message
sravanthireddychada
Messages: 6
Registered: July 2007
Location: india
Junior Member
Thank you for your reply.
I'm using oracle 9i version oracle 9.2.0.0. Please tell me the backup restore method in detail.I won't use any backups for my database, so if any procedure like default backup techniques are there please let me know them and also the recovery techniques.
once again thank you.

from Sravanthi Reddy

[Updated on: Sat, 04 August 2007 04:04]

Report message to a moderator

Re: demo tables(emp,dept) recovery in scott [message #256395 is a reply to message #256393] Sat, 04 August 2007 04:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you don't have any backup then you cannot restore.

Oracle9i Backup and Recovery Concepts

Regards
Michel
Re: demo tables(emp,dept) recovery in scott [message #256406 is a reply to message #256395] Sat, 04 August 2007 07:07 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
You could have searched the board.

Edit: Google helped me out too: link 1, link 2.

MHE

[Updated on: Sat, 04 August 2007 07:10]

Report message to a moderator

Re: demo tables(emp,dept) recovery in scott [message #406401 is a reply to message #256080] Wed, 03 June 2009 17:30 Go to previous messageGo to next message
snu1234
Messages: 1
Registered: June 2009
Junior Member
To restore demo tables of scott user u can call the DEMOBLD.SQL in SQL plus. first u need to find the file in oracle database and give run the file through this command
for 9i
SQL > @drive:\oracle\ora90\sqlplus\demo\demobld
For 10g
SQL>@drive:\oracle\product\10.2.0\db_1\ODP.NET\samples\DataSet\RelationalData\\setup\demobld
run it any time it will rebuild demo tables

[Updated on: Wed, 03 June 2009 17:37]

Report message to a moderator

Re: demo tables(emp,dept) recovery in scott [message #406803 is a reply to message #406401] Fri, 05 June 2009 23:49 Go to previous message
sravanthireddychada
Messages: 6
Registered: July 2007
Location: india
Junior Member
Thank You.
Previous Topic: different results in differen databases on the same tables containing the same data (merged 4)
Next Topic: Problem with nested types (merged)
Goto Forum:
  


Current Time: Tue Dec 06 06:49:44 CST 2016

Total time taken to generate the page: 0.10986 seconds