Re: Export weirdness

it appears that the NOT NULL constraint on col SITE_ID is was not created for some reason.

the PRIMARY KEY constraint (when it is enabled) will not allow any column included in the primary key to contain a NULL.

the output of the SQL*Plus describe command is showing that the column does not have a NOT NULL constraint.

There are several parameters on the export and import that can affect the behavior. One possibility is that the table already existed, and IGNORE=Y was specified on the import.

<kal121_at_my-deja.com> wrote in message
news:8knclf$hhl$1_at_nnrp1.deja.com...
> Hello,
>
> I did an export from one database to another, so now the
 schemas, data,
> etc is identical on both databases.
>
> However, when I do a describe on the database that I imported
 to, the
> primary key field shows up as null. Yes, the primary key does
 exist!
> It's just not showing up:
>
> Exported from:
> SQL> desc table1
> Name Null? Type
> ---------------------------------- -------- -------------
> SITE_ID NOT NULL NUMBER(38)
>
> Imported to (primary key DOES exist):
> SQL> desc table1
> Name Null? Type
> ---------------------------------- ------- --------------
> SITE_ID NUMBER(38)
>
> Wonder why this is???
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Fri Jul 14 2000 - 00:00:00 CDT