OraFAQ Forum: Enterprise Manager » Exporting objects to SQL statement

Home » RDBMS Server » Enterprise Manager » Exporting objects to SQL statement

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

Exporting objects to SQL statement [message #68240]

Sat, 15 February 2003 12:53

midbie
Messages: 4
Registered: February 2003

Junior Member

Hi all,

Is it possible to export objects (eg. users, tables, procedures, etc.) and their access right to a file in SQL statement? Say, for a table, its create and grant script are exported to a file.

i know there is a command 'exp' to do thing like this, but it outputs a binary file which I cant read. And I also know I can do it in OEM and its export exactly what i want, but it seems have to export object one by one manually. So, I think cant use these methods...

Please help and many thanks in advance.

midbie

Report message to a moderator

Re: Exporting objects to SQL statement [message #68241 is a reply to message #68240]

Mon, 17 February 2003 06:55

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i believe, you are looking to extract the DDL of schema and objects.
this functionality is inlcuded in many tools like sqlnavigator and dbartisan.
in OEM it is partiallyy implemented( click show sql).
with exp/imp also do something.
do the regular export of whatever object u wnat.
and while import show=y just displays the ddl (from the export file).
redirect the output to a txt file....

Report message to a moderator