Hi,

I want to have a backup script that exports all the DDL for each user
in the database. All grants, privileges, indexes, tables, types, etc.

I'm having trouble creating one that does all the object types. I'm
trying lots of examples, but none are really working because I want to
do this in a script, spooling each schema to a different file, and
make sure it is all objects, meaning types, synonyms, privileges, etc.

Thanks in advance!

On 10/20/2011 11:16 PM, ExecMan wrote:
What exactly is your question now? What did you try and which problems
did you encounter?

I'd say as a general hint you need PL/SQL package DBMS_METADATA (notably
GET_DDL) and combine that with a query on ALL_OBJECTS, USER_OBJECTS or
DBA_OBJECTS.

Kind regards

robert

"ExecMan" <artmerar (AT) yahoo (DOT) com> a écrit dans le message de news: 704a827b-d4e5-493e-91e3-2fcd9e2101d0...oglegroups.com...
expdp / full=Y content=METADATA_ONLY

Regards
Michel