If you need more help you can also check out asktom.oracle.com. Tom Kyte is one of the best, if not THE best, Oracle guru out there. He answers all questions with examples and proofs. It's not too often that I can't find an answer to my question already out there. -Pete On 10/12/06, Greg Siems <Gregory.Siems at state.mn.us> wrote: > > 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.dmpindexfile= > 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 > > > _______________________________________________ > TCLUG Mailing List - Minneapolis/St. Paul, Minnesota > tclug-list at mn-linux.org > http://mailman.mn-linux.org/mailman/listinfo/tclug-list > -------------- next part -------------- An HTML attachment was scrubbed... URL: http://mailman.mn-linux.org/pipermail/tclug-list/attachments/20061013/a2230fb6/attachment-0001.htm