Home » RDBMS Server » Enterprise Manager » Exporting objects to SQL statement
Exporting objects to SQL statement [message #68240] Sat, 15 February 2003 12:53 Go to next message
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
Re: Exporting objects to SQL statement [message #68241 is a reply to message #68240] Mon, 17 February 2003 06:55 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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....
Re: Exporting objects to SQL statement [message #68244 is a reply to message #68240] Tue, 18 February 2003 07:06 Go to previous messageGo to next message
midbie
Messages: 4
Registered: February 2003
Junior Member
Could you please show me the exactly command on unix base system.

I tried with sth like ..... > db.sql

but nothing write to the file...

thx
Re: Exporting objects to SQL statement [message #68476 is a reply to message #68240] Wed, 22 October 2003 07:35 Go to previous message
Denis
Messages: 8
Registered: December 2000
Junior Member
i think it possible by Script extractor utility -
http://www.scriptextractor.boom.ru
Previous Topic: How to log in to the OEM?
Next Topic: OEM defragmentation tool for version 9 client
Goto Forum:
  


Current Time: Thu Mar 28 09:42:08 CDT 2024