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

Thread: Import error - BLOB DATATYPE

  1. #1
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306

    Import error - BLOB DATATYPE

    HI

    Oracle 8.1.7.4 - latest patch applied
    win 2k server box.

    I have taken a export of a single table which has blob datatype and it has 359 records , while i try to import it into another tablespace having different SID it fails , can any one tell me why ???
    It says tablespace ossbss doesnot exist

    OSSBSS IS the tablespace in which page_help is there and which has blob datatype.


    My export script.
    ==================
    D:\oracle\ora81\bin\exp userid=ossbss/ossbss tables=page_help file=D:\oracle\ora81\bin\pagehelp.dmp log=d:\oracle\ora81\bin\pagehelp.log

    My import script
    ==============
    D:\oracle\ora81\bin\imp system/manager fromuser=ossbss touser=hnsjuly tables=page_help file=D:\oracle\ora81\bin\pagehelp.dmp

    Error
    ========
    import done in US7ASCII character set and US7ASCII NCHAR character set
    export client uses WE8ISO8859P1 character set (possible charset conversion)
    export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)
    IMP-00017: following statement failed with ORACLE error 959:
    "CREATE TABLE "PAGE_HELP" ("ID" VARCHAR2(25) NOT NULL ENABLE, "PAGE_NAME" VA" "RCHAR2(255) NOT NULL ENABLE, "CONTENT" BLOB, "NOTE" VARCHAR2(1000)) PCTFRE" "E 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 696320 NEXT"
    " 335872 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50 FREELISTS 1 FREELIST GRO" "UPS 1 BUFFER_POOL DEFAULT) TABLESPACE "OSSBSS" LOB ("CONTENT") STORE AS (T" "ABLESPACE "OSSBSS" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE " "STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505 PCTINCREASE 50"
    " FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
    IMP-00003: ORACLE error 959 encountered
    ORA-00959: tablespace 'OSSBSS' does not exist
    Import terminated successfully with warnings.
    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  2. #2
    Join Date
    Oct 2003
    Posts
    38
    Hi, YOU do not have ossbss tablespace in your database where you are importing. If you look at the script it is creating the table with tablespace ossbss. In your import command try out giving IGNORE=y, Commit=Y.

    If this do not work. Get the create table script and edit the script to change tablespace name from ossbss to the available tablespace name and use the imp command with IGNORE=Y , commit=Y.

    . Let me know if that worked.

  3. #3
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    It is working now

    First I created the table with create table script.

    Table got created

    Then i ran the import command with option IGNORE=Y

    It imported all the rows without any warnings.

    Thanks a lot prince.

    Pravin
    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

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