OraFAQ Forum: Server Utilities » DDL for Procedure, Triggers, Function, Packages

Home » RDBMS Server » Server Utilities » DDL for Procedure, Triggers, Function, Packages

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DDL for Procedure, Triggers, Function, Packages [message #74109]

Mon, 13 September 2004 04:12

Avra
Messages: 65
Registered: July 2004

Member

Hi.. Is it possible to generate the DDL statement for Procedure, Triggers, Function, Packages from a .dmp file without actually importing the .dmp file?

Thanks...

Report message to a moderator

Re: DDL for Procedure, Triggers, Function, Packages [message #74114 is a reply to message #74109]

Mon, 13 September 2004 15:59

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Try these to get all the DDL:
imp scott/tiger file=scott.dmp show=y log=scott_ddl.txt

--in Unix:
strings scott.dmp > scott_ddl.txt

Report message to a moderator

Re: DDL for Procedure, Triggers, Function, Packages [message #74115 is a reply to message #74114]

Mon, 13 September 2004 21:04

Avra
Messages: 65
Registered: July 2004

Member

Hi.. Thanks for your reply... I'm using Win2000 Prof as my OS and I've tried with the parameter... But it will generate all DDL related to tables only.. It's not generating DDL related to Procedure, Triggers, Function, Packages....

Bye......

Report message to a moderator

Re: DDL for Procedure, Triggers, Function, Packages [message #74120 is a reply to message #74109]

Wed, 15 September 2004 07:48

ded_mozaj
Messages: 1
Registered: September 2004

Junior Member

select *
from user_source

Report message to a moderator

Previous Topic:	Export warning
Next Topic:	how to change the table_name in oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 12 14:16:34 CST 2024