Re: Schema DDL
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 22 Oct 2011 09:52:30 +0200
Message-ID: <4ea2763e$0$25918$426a74cc_at_news.free.fr>
Date: Sat, 22 Oct 2011 09:52:30 +0200
Message-ID: <4ea2763e$0$25918$426a74cc_at_news.free.fr>
"ExecMan" <artmerar_at_yahoo.com> a écrit dans le message de news: 704a827b-d4e5-493e-91e3-2fcd9e2101d0_at_k35g2000yqh.googlegroups.com...
| 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!
expdp / full=Y content=METADATA_ONLY
Regards
Michel
Received on Sat Oct 22 2011 - 09:52:30 CEST