Home » SQL & PL/SQL » SQL & PL/SQL » Help me Please (Oracle9i,WindowsXP)
icon9.gif  Help me Please [message #386019] Thu, 12 February 2009 04:27 Go to next message
Messages: 5
Registered: August 2008
Junior Member
Hi all,

I have some problem here , hope u people help me out of this problem.

My problem is,

In Scott schema, Emp is the default table having some predefined column. I am regularly use this table but by mistake the table is deleted by me.Now i want to get that default(EMP) table as it original form.
Can it be possible ???

In my knowledge some file is present in the oracle home directory,which need to copy and past, so that it gives the original forms of Scott schema table structure.
But i forgotten that file and where it is present.

so anybody help me.

Deb Smile
Re: Help me Please [message #386022 is a reply to message #386019] Thu, 12 February 2009 04:30 Go to previous messageGo to next message
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Instead of posting in this forum if you would have used google you would have got the answer immediately.

check this link.




P.S : I got this link only by googling.

Re: Help me Please [message #386029 is a reply to message #386019] Thu, 12 February 2009 04:49 Go to previous message
Michel Cadot
Messages: 65079
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Also as it is clearly showed by the red ball in the sticky at the top of the forum you should FIRST search, this question has been asked and answered many times.

Previous Topic: Oracle SQL questions
Next Topic: how to store the 15 digit decimal value ? (merged 4)
Goto Forum:

Current Time: Thu Jul 20 11:27:50 CDT 2017

Total time taken to generate the page: 0.10182 seconds