My object type doesn't export

From: <gaop_at_my-deja.com>
Date: Fri, 24 Sep 1999 18:00:06 GMT
Message-ID: <7sge6t$env$1@nnrp1.deja.com>

I have created an object type under a schema. I have created a table with one of columns using that object type under a different user. When I tried to export the table under the user who owns the table, I got the error "OCI-22303: type ""."GC_GRID" not found". The following is my export session.

What did I do wrong?

Thanks for any help.

Gao Peng

---

Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
Enter array fetch buffer size: 4096 >

Export file: EXPDAT.DMP >

(2)U(sers), or (3)T(ables): (2)U > T

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

About to export specified tables via Conventional Path ... Table(T) or Partition(T:P) to be exported: (RETURN to quit) > mygrid

. . exporting table                         MYGRID

EXP-00056: ORACLE error 22303 encountered OCI-22303: type ""."GC_GRID" not found
Table(T) or Partition(T:P) to be exported: (RETURN to quit) >

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 24 1999 - 13:00:06 CDT