-
I have a table containing CLOB field. When I try to delete the rows, it shows me following erro:
ORA-22275: invalid LOB locator specified
When I try to drop the table it shows following error:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys
Can somebody out there help me please? And also I want to know how can I load CLOB data into database using SQL Loader?
Agasimani
OCP(10g/9i/8i/8)
-
The control file for loading BLOB/CLOB is:
load data
infile 'test_lob.dat'
append into table test_lob
fields terminated by ','
(id , name, external_filename FILLER,
name_lob LOBFILE(external_filename) TERMINATED BY EOF
)
Please note that when you create a table set default value EMPTY_CLOB() / EMPTY_BLOB() to the LOB column.
The table creation script is :
CREATE TABLE TEST_LOB ( ID NUMBER , NAME VARCHAR2(30), NAME_LOB BLOB DEFAULT EMPTY_BLOB());
-
When you drop the table, try use "cascade constraints" option.
(Specify CASCADE CONSTRAINTS to drop all referential integrity constraints that refer to primary and unique keys in the dropped table. If you omit this clause, and such referential integrity constraints exist, Oracle returns an error and does not drop the table.)
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|