In the Schema Browser Im trying to use the option, Copy data to another schema when right-clicking a particular table that contains a datatype, SDO_Geometry in one of its columns and I get the following error after clicking on execute:
ORA-04043: object SDO_GEOMETRY does not exist
Other tables are fine, except for this table because of this datatype.
WORKAROUND:
Use Create in Another Schema Option
1. Right-click the table in the schema browser.
2. Select Create in another schema option from the sub-menu.
3. In the Tables tab, make sure the Insert Statements check box is checked.
4. Uncheck the Drop Statement check box (to avoid errors about the table not existing)
5. Click OK.
6. Set the destination Schema and click Execute. (Password may be required).
STATUS:
Waiting for fix to be released in a future version of Toad for Oracle.
