If you need more help you can also check out <a href="http://asktom.oracle.com">asktom.oracle.com</a>. 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.
<br><br>-Pete<br><br><div><span class="gmail_quote">On 10/12/06, <b class="gmail_sendername">Greg Siems</b> <<a href="mailto:Gregory.Siems@state.mn.us">Gregory.Siems@state.mn.us</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;">
Nice. That sounds even better than trying to wrangle the dbms_metadata<br>package (which doesn't seem to work quite right in 9i*-- It's supposed<br>to be fixed in 10g).<br><br>I'll have to try that out.<br><br>--greg<br><br>
* It insists on wrapping at column 80 in sqlplus and 'set line size xxx'<br>has absolutely no effect.<br><br><br>On Thu, 2006-10-12 at 09:22 -0500, John Meier wrote:<br>> On 10/11/06, Peter Chase <<a href="mailto:peter.chase@gmail.com">
peter.chase@gmail.com</a>> wrote:<br>> > 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>><br>> Used to do a bunch of oracle dba stuff years back and had to ask a<br>> friend about this one - I can remember doing somehting like this, but<br>> old age has taken those memories... My friend reminded me of this:
<br>><br>> Run an import w/ SHOW=Y & LOG=<filename> Instead of actually having<br>> it import dmp file, it'll display what it "would" import...therefore<br>> showing you all the DDL.<br>
><br>> Thought it might help.<br>><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>> ><br>> ><br>> > On 10/11/06, Damien DeZurik <<a href="mailto:ddezurik@yahoo.com">ddezurik@yahoo.com</a>> wrote:<br>> > > 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>> > ><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>> ><br>> ><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><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>