Re: Data Standards on Database Export->Import

2005-03-24 Thread Z X C V
Stephen, That is interesting... The DBA and Oracle programmers are really raising an issue on the difficulties of this extraction. We can use a ~ delimited file but were told to give "our" standards. To which now they are saying is out of time scope. Thank you for this information since it give

Re: Data Standards on Database Export->Import

2005-03-23 Thread Stephen Andert
Actually, exporting data from an Oracle database is one of the weak spots of Oracle. Oracle makes it easy to get data in, but hard to get it back out. There are ways to do it, but nothing easy that an Oracle DBA will have if they only read the Oracle docs. Spooling an output file can get tedius

Re: Data Standards on Database Export->Import

2005-03-22 Thread SGreen
Z X C V <[EMAIL PROTECTED]> wrote on 03/21/2005 08:32:24 PM: > > Hello, > > Are there any good rfcs or other documents that would assist in the > discussion I'm having with our organization's Oracle programmers in > regards the following: > > Oracle DB -> MySQL > > They recommend: > > ~ col

Data Standards on Database Export->Import

2005-03-21 Thread Z X C V
Hello, Are there any good rfcs or other documents that would assist in the discussion I'm having with our organization's Oracle programmers in regards the following: Oracle DB -> MySQL They recommend: ~ col~col ~col~ col'",~col NOTE::I placed the '" in for a reason. I am looking for: "col","col"