Pete and John, Great suggestions, just the kind of thing I was looking for. There must be reasons that I just don't understand as to why you can't just do something like $> exp liveDbHandle --no-schema scriptfile=fullTextDump.sql Or maybe you can based on Pete's suggestions. Haven't looked into it yet but will do so later today. Thanks!! Damien --- John Meier <john.meier at gmail.com> 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 >