Solving Oracle ORA-00997, ORA-00932 and ORA-22804 Errors
Q: I am getting Oracle ORA-00997, ORA-00932 or ORA-22804 errors while trying
to copy data between tables, between schemas or via a database link.
A:Oracle provides very poor support for the transfer of data stored in
complex datatypes. Read on for a solution to this problem.
DataBee now handles Oracle User Defined Data Types.
In version 8i of its database server Oracle introduced object-relational technologies.
These new features enable complex data to be modeled as objects and
information to be described within custom data types. A collection of such objects
can be presented as a table or imbedded into other tables as a column of a "User Defined
Type".
It is hard to copy object-relational data.
Such object-relational technology is an extremely versatile and powerful method for
storing data. However, the technology is not without a few drawbacks. Using
Oracle's standard technologies the only
way to copy object-relational data between schemas is to write custom PL/SQL code to
handle each object type. Moving such data between databases adds
yet another layer of complexity (see Metalink Note: 136352.1).
No more ORA-00997, ORA-00932 or ORA-22804 errors while transferring data.
DataBee contains low level internal routines that completely bypass Oracles
normal transfer mechanisms. This means you can copy data in the form of Nested Tables,
Object Tables, VARRAYS, LONG and LONG RAW columns without writing any custom handling
code - its all point and click. Such data (even Oracle Spatial data) is handled
transparently and can be copied between schemas and databases as required.
For more information on the DataBee software and free evaluation downloads please
see the DataBee home page.
