is there any script from which u can
get the create statement of your all objects in your database
i.e tables, procedure ,sequence etc
if it there then pls. tell me
it is urgent
thanks in advance
Printable View
is there any script from which u can
get the create statement of your all objects in your database
i.e tables, procedure ,sequence etc
if it there then pls. tell me
it is urgent
thanks in advance
You can do this by using exp/imp.
exp .... ROWS=N ...
imp .... SHOW=Y ...
Hope this helps
Gert
Refer the CD that comes free with "Oracle Database Administration The essential Reference" Oreilly Publications. The CD has all the create object scripts (for tables, index,functions,triggers etc)
Hope that will help.
However, if you require for any particular object specify along with your mailId, so that i can mail you.
Manjunath