Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Copy Oracle spatial tables to remote computer
Burnet,
> How it is possible to copy a such table on a remote computer ?
yes, but you'll have to copy more than just the table. If you read the error closely, you'll see that it can't copy due to the fact that the table is an "object table" or built with user-defined object types. So aside from just the table, you'll also need to copy the TYPE definition as well. This can be easily accomplished if you export/import the entire schema (assuming that one schema owns it all). Otherwise, you can copy the table to a similar table that is comprised of the same attributes, but not using object types. Then copy that table to the remote database. Then do a similar copy into a spatial table.
HTH,
Brian
Received on Wed Jul 18 2001 - 08:05:25 CDT