Copy Data with CLOB data field
Posted on 2005-02-25
I am doing the data migration, Oracle 9i
One table I have to copy from staging to Production has CLOB type.
I using copy command to copy over the data. All the tables are getting copied but the one with field CLOB data type.
When I try to do that it gives me the following error:
" CPY0012: Object datatypes cannot be copied"
Please suggest how to copy the data of this table into production having CLOB data rtype.
Table looks like this
CREATE TABLE ORDEREDSERVICE
ID NUMBER(8) NOT NULL,
LOCATION VARCHAR2(128 BYTE),
USE_CLOB NUMBER(1) DEFAULT 0 NOT NULL,
PARAM_TEXT1 VARCHAR2(4000 BYTE),
PARAM_TEXT2 VARCHAR2(4000 BYTE),
SVCADDRESS_ID NUMBER(8) NOT NULL,
SCHEMA_NAME VARCHAR2(30 BYTE) DEFAULT USER