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 > > >