| Exporting objects to SQL statement [message #71990] |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
