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:<br><br>exp username/password owner=schema1 file=data.dmp<br>imp username/password fromuser=schema1 touser=schema2 file=
data.dmp<br><br>The username I typically use is one with the DBA role.<br><br>The other option to exp that I'll use:<br><br>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.
<br>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).<br><br>Hope this helps.<br><br>-Pete<br><br>
<div><span class="gmail_quote">On 10/11/06, <b class="gmail_sendername">Damien DeZurik</b> <<a href="mailto:ddezurik@yahoo.com">ddezurik@yahoo.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi, I hope this isn't too off topic but is regarding<br>Oracle on a Linux platform ...<br><br>I am looking for the equivalent of mysqldump to run on<br>an Oracle 9i database. But there is more. It needs<br>to be an oracle product or Toad (for QA purposes). I
<br>need to dump a text script of an entire Oracle 9i<br>database with all table structure, views, triggers,<br>packages, functions, procedures, sequences, etc ...<br>all of it but here is the kicker. It needs to be<br>schema independent.
<br><br>So, instead of:<br>CREATE OR REPLACE TRIGGER myschema.update_audit_row<br>...<br><br>It needs to dump:<br>CREATE OR REPLACE TRIGGER update_audit_row ...<br><br>Is this even possible? Is there something I am<br>missing? Can Sql*Plus do this for me?
<br><br>I already tried using TOAD to dump the data as a<br>script and it was almost perfect except using Export<br>Source Code prepends the schema name all over the<br>place and I can't seem to figure out how to make it<br>
not do that.<br><br>I could also just use Toad and then use sed or similar<br>to strip out all the references to schema after the<br>dump is created but this won't fly (QA again). The<br>generated script must be run with out modification.
<br><br>So, anyone know of an oracle tool like:<br><br>OraOnLinux $> oradump --no-schema --no-data ><br>fullDatabaseCopy.txt<br><br>Any help is appreciated,<br>Thanks!<br>Damien<br><br><br>_______________________________________________
<br>TCLUG Mailing List - Minneapolis/St. Paul, Minnesota<br><a href="mailto:tclug-list@mn-linux.org">tclug-list@mn-linux.org</a><br><a href="http://mailman.mn-linux.org/mailman/listinfo/tclug-list">http://mailman.mn-linux.org/mailman/listinfo/tclug-list
</a><br></blockquote></div><br>