OraFAQ Forum: Client Tools » Generate Scripts For All Object

Home » Other » Client Tools » Generate Scripts For All Object

Mon, 17 September 2007 23:13

ramanathan manickam
Messages: 27
Registered: July 2007

Junior Member

Is there any tool or method to generate scripts for all the objects
of the given oracle database ?

DBMS: Oracle10G

Mon, 17 September 2007 23:15

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

You write a pl/sql to generate.

look at DBMS_METADATA.GET_DDL('OBJECT TYPE','OBJECT_NAME');

Tue, 18 September 2007 01:04

muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh

Senior Member

You can get an overview of DBMS_METADATA package following link
http://www.psoug.org/reference/dbms_metadata.html

[Updated on: Tue, 18 September 2007 01:07]

Tue, 18 September 2007 01:07

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

You can also use any client tool to generate. Like tora.

Previous Topic:	how to open my sql editor in browser
Next Topic:	Dual Oracle Client Homes

Goto Forum:

]

Current Time: Fri Jan 03 08:13:08 CST 2025