Re: Exporting Oracle Database into text file

Some Guy wrote:
>
> yoong pan wrote:
>
> > Is there a way to export oracle database into a delimited text file?
> >
> > Also, is there a way to import oracle database into ms-SQL server?
> >
> > Thanks.
> >
> > --
> > ---------------------------------
> > | Eric Y. Pan (~{EKHYG?~} )
> > | http://www.mech.utah.edu/~pan
>
> Use sqlloader's export function. It will write out insert
> statements. You might be able to modify these easily if ti is a one
> time thing.

Hi,
To create text file of oracle database, use 'SQl*PLUS' tool with the SPOOL command and . Use MS SQL SERVER 'BCP' utility to load the text file from oracle.
Hope this helps

-- 
    AMARENDRA B NETTEM
    Certified Oracle DBA
    WHITTMAN-HART INC., CHICAGO
    Homepage : http://www.iit.edu/~nettama
    E-mail : anettem_at_whittman-hart.com
             nettama_at_charlie.cns.iit.edu