| From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
|---|---|
| To: | "Carlos Sousa" <carlosdsousa(at)hotmail(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: bigger problem |
| Date: | 2002-11-11 18:13:29 |
| Message-ID: | web-1821180@davinci.ethosmedia.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Carlos,
> in postgres database i created a table with a field like
>
> create table (...)
> (...)
> var text default '' not null
> (...)
>
> now i need to import the data from this table into a oracle database
> i used pg_dump
>
> I altered the field data type to
>
> (...)
> var varchar2(50) default '' not null
> (...)
>
> but when i was importing the the table into the oracle database all
> the rows with the field var='' were not inserted.
> Is there a way to work this around
This is a problem with your configuration of Oracle import. See your
Oracle documentation; we cannot help you here.
-Josh Berkus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2002-11-11 18:27:59 | Re: Generating a cross tab (pivot table) |
| Previous Message | Josh Berkus | 2002-11-11 17:59:56 | Re: Permission on insert rules |