Nice. That sounds even better than trying to wrangle the dbms_metadata package (which doesn't seem to work quite right in 9i*-- It's supposed to be fixed in 10g). I'll have to try that out. --greg * It insists on wrapping at column 80 in sqlplus and 'set line size xxx' has absolutely no effect. On Thu, 2006-10-12 at 09:22 -0500, John Meier wrote: > On 10/11/06, Peter Chase <peter.chase at gmail.com> wrote: > > There is imp and exp you can use. Run "exp -help" and "imp -help" for the options. The output from the command is a binary file, however if you need to pull just the structure out you can with run "exp file= file.dmp indexfile=outfile.sql". A quick example of doing an export and importing it to a different schema: > > > > exp username/password owner=schema1 file=data.dmp > > imp username/password fromuser=schema1 touser=schema2 file= data.dmp > > > Used to do a bunch of oracle dba stuff years back and had to ask a > friend about this one - I can remember doing somehting like this, but > old age has taken those memories... My friend reminded me of this: > > Run an import w/ SHOW=Y & LOG=<filename> Instead of actually having > it import dmp file, it'll display what it "would" import...therefore > showing you all the DDL. > > Thought it might help. > > > > The username I typically use is one with the DBA role. > > > > The other option to exp that I'll use: > > > > direct=y This will bypass much of the undo that Oracle needs to write out when importing the data back in. This means fewer log switches, and faster imports. > > consistent=y If you are doing an active schema this will make sure all the data is consistent from the time you started the import. (The wonders of read consistency). > > > > Hope this helps. > > > > -Pete > > > > > > > > On 10/11/06, Damien DeZurik <ddezurik at yahoo.com> wrote: > > > Hi, I hope this isn't too off topic but is regarding > > > Oracle on a Linux platform ... > > > > > > I am looking for the equivalent of mysqldump to run on > > > an Oracle 9i database. But there is more. It needs > > > to be an oracle product or Toad (for QA purposes). I > > > need to dump a text script of an entire Oracle 9i > > > database with all table structure, views, triggers, > > > packages, functions, procedures, sequences, etc ... > > > all of it but here is the kicker. It needs to be > > > schema independent. > > > > > > So, instead of: > > > CREATE OR REPLACE TRIGGER myschema.update_audit_row > > > ... > > > > > > It needs to dump: > > > CREATE OR REPLACE TRIGGER update_audit_row ... > > > > > > Is this even possible? Is there something I am > > > missing? Can Sql*Plus do this for me? > > > > > > I already tried using TOAD to dump the data as a > > > script and it was almost perfect except using Export > > > Source Code prepends the schema name all over the > > > place and I can't seem to figure out how to make it > > > not do that. > > > > > > I could also just use Toad and then use sed or similar > > > to strip out all the references to schema after the > > > dump is created but this won't fly (QA again). The > > > generated script must be run with out modification. > > > > > > So, anyone know of an oracle tool like: > > > > > > OraOnLinux $> oradump --no-schema --no-data > > > > fullDatabaseCopy.txt > > > > > > Any help is appreciated, > > > Thanks! > > > Damien > > > > > > > > > _______________________________________________ > > > TCLUG Mailing List - Minneapolis/St. Paul, Minnesota > > > tclug-list at mn-linux.org > > > http://mailman.mn-linux.org/mailman/listinfo/tclug-list > > > > > > > > > _______________________________________________ > > TCLUG Mailing List - Minneapolis/St. Paul, Minnesota > > tclug-list at mn-linux.org > > http://mailman.mn-linux.org/mailman/listinfo/tclug-list > > > > > > > > _______________________________________________ > TCLUG Mailing List - Minneapolis/St. Paul, Minnesota > tclug-list at mn-linux.org > http://mailman.mn-linux.org/mailman/listinfo/tclug-list