Board index Oracle

My object type doesn't export

My object type doesn't export

Post by g.. » Sun, 31 Dec 1899 09:00:00



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.

 
 
 
Top

My object type doesn't export

Post by Mrs. Galina Istomina & Mr. Vladimir Starko » Sun, 31 Dec 1899 09:00:00


In Oracle 8 you can export object definitions ONLY in
FULL, COMPLETE, CUMULATIVE and INCREMENTAL mode !

With Best Regards
Mr. Vladimir V. Starkov
Oracle Certified Professional DBA

 
 
 
Top

My object type doesn't export

Post by John Chi » Sun, 31 Dec 1899 09:00:00


If you export by table, you miss out the type definition. Use Full export
instead.

John Chiu

 
 
 
Top

1. mmmyql driver doesn't store a vector object in mysql database (changes serialized object string)

hello,

i'd appreciate any help on the problem i keep having since i'm running
out ouf ideas.
i tried to store a vector object using the mmmysql driver 1.2 and 2.0pre
in a mysql database (win32 version 3.21).
as you can imagine, the serialized vector object contains a lot of
unusual ascii characters. when i write the object to a file and read it
in using "load infile .." mysql inserts it without any problems.
using the drivers setObject() or setBinaryStream() methods not a single
character of the object reaches the database, just two ascii signs (not
contained in the serialized object string) and a lot of spaces.
to make it even worse, a result query (ResultSet rs
= executeQuery("select * from tableX")) to select this row doesn't even
return!!

if anyone could help me, i'd be glad.

thanks in advance,

sebastian

PS: i tried the original "store objects in database for persistence"
example in http://www.codeguru.com with the same result

Sent via Deja.com http://www.deja.com/
Before you buy.

2. Fractional seconds in a DATE field?

3. '(dbo)' appended to exported objects

4. ?? Restructure with pushbutton ? ?

5. Question about objects whose object_type='TYPE'

6. question about indexes

7. Printing to file

8. DTS export to Access then email doesn't work

9. DTS doesn't Import/Export Identity column details

10. SP2 doesn't export Description varchar(4096) field

11. export doesn't happen


All times are UTC
Board index