-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|