Export weirdness

From: <kal121_at_my-deja.com>
Date: 2000/07/14
Message-ID: <8knclf$hhl$1@nnrp1.deja.com>#1/1

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