Home » SQL & PL/SQL » SQL & PL/SQL » demobld
demobld [message #190472] Wed, 30 August 2006 23:54 Go to next message
sunsanvin
Messages: 60
Registered: April 2006
Location: Hyderabad
Member

Hi Experts, actually i dropped emp table.but i need the same table once again.for that in my institute, i used some !demobld. but it is not working.i copied that code from oracle site and saved as demobld.sql.now how can i specify the path of that file to oracle?or is there any othre way to do this?

thank you very much for seeing my doubt
icon2.gif  Re: demobld [message #190477 is a reply to message #190472] Thu, 31 August 2006 00:24 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
hi i would like you to be more clear.that file might have been a .buf,and what exactly do you want to do now?do you want to create all the tables?
icon2.gif  Re: demobld [message #190478 is a reply to message #190472] Thu, 31 August 2006 00:25 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
hi i would like you to be more clear.and what exactly do you want to do now?do you want to create all the tables?
Re: demobld [message #190479 is a reply to message #190472] Thu, 31 August 2006 00:27 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
In sqlplus, to start a script you use either 'start' or the at-sign (@):
@path/to/your/file/demobld.sql
Re: demobld [message #191377 is a reply to message #190479] Wed, 06 September 2006 01:36 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
In case you can't find them they are on the board.

MHE
Previous Topic: Problem with view
Next Topic: trigger : problem in old.columnvalue(urgent)
Goto Forum:
  


Current Time: Wed Dec 07 18:35:28 CST 2016

Total time taken to generate the page: 0.09678 seconds