Schema DDL
From: ExecMan <artmerar_at_yahoo.com>
Date: Thu, 20 Oct 2011 14:16:02 -0700 (PDT)
Message-ID: <704a827b-d4e5-493e-91e3-2fcd9e2101d0_at_k35g2000yqh.googlegroups.com>
Hi,
Date: Thu, 20 Oct 2011 14:16:02 -0700 (PDT)
Message-ID: <704a827b-d4e5-493e-91e3-2fcd9e2101d0_at_k35g2000yqh.googlegroups.com>
Hi,
[Quoted] [Quoted] 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! Received on Thu Oct 20 2011 - 23:16:02 CEST