LOB Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: LOB Problem

  1. #1
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    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)

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    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());


  3. #3
    Join Date
    Oct 2000
    Posts
    123
    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
  •  



Click Here to Expand Forum to Full Width