Thanks for info.

Out of 3 solutions, I felt #3 should be ideal, but when I tried that it
gave me below error.

IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'TEST_LOB'

So now we are back to square 1 where we have to either pre-create table
or to have same tablespace
Name every where we take the dump.


-----Original Message-----
From: Cameron Pam
[mailto:oracledba-ezmlmshield-x38823248.[Email address protected]
Sent: Thursday, November 11, 2004 10:51 AM
To: LazyDBA Discussion
Subject: RE: ORA-00959 -- error.

This is what I found out on MetaLink:

Displayed below are the messages of the selected thread.


IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'ABC' does not exist


There are at least three ways to get around this:
1) Extract the table creation SQL for the tables that won't import,
and pre-create them in the right tablespace and re-import the tables
with
the ignore=yes setting.
2) Create a tablespace of the appropriate name to hold the tables and
import
them there.
3) Create a tiny tablespace of the appropriate name and grant the user
zero
quota on that tablespace (this causes the user's default tablespace to
be
used by imp).


Hope that it helps...



Pamela


-----Original Message-----
From: Krishna Kandula
[mailto:oracledba-ezmlmshield-x91636391.[Email address protected]
Sent: Wednesday, November 10, 2004 6:08 PM
To: LazyDBA Discussion
Subject: RE: ORA-00959 -- error.

As far as I know, you can't export LOB or BLOB. because the data in
those
columns are stored in reference points.
My suggestion is create the table first with proper assignment for BLOB
tablespace since you are using the option IGNORE=Y, it will load the
data
without creating the table.


Krishna

-----Original Message-----
From: Mohan Kumar
[mailto:oracledba-ezmlmshield-x95459455.[Email address protected]
Sent: Wednesday, November 10, 2004 5:55 PM
To: LazyDBA Discussion
Subject: FW: ORA-00959 -- error.


Still looking for help.



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page