Re: Help with loading data from PostgreSQL into Oracle

set scan off

HTH
Dimitre Radoulov

• Original Message ----- From: "Chris Hoover" <revoohc_at_gmail.com> To: <Oracle-L_at_freelists.org> Sent: Friday, June 17, 2005 3:32 PM Subject: Help with loading data from PostgreSQL into Oracle

>I need some help getting data from PostgreSQL to load into Oracle. I
> have extracted the PostgreSQL data into a file as insert statements.
> However, I am having a problem I'm not sure how to handle. Sqlplus is
> interpreting some of the data that is in the strings. How can I turn
> this off? Forgive me if this is trivial, but it has been several
> years since I've done much work with Oracle.
>
> Here are some examples of what is going on.
>
> insert into table x values (1,'map: abcdefg');
> sqlplus asks for a value for map:
>
> insert into table y values ('test values','this & that');
> sqlplus ask for a value for that.
>
> How can I stop this? I need sqlplus to load the data as given and not
> try to "interpret it".
>
> thanks,
>
> chris
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l