Please ignore my previous comment, which is incorrect - you can store LOBs
in a locally managed tablespace as well.

Jannes

>From: "Jannes de Klerk "
><oracledba-ezmlmshield-x52254190.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Subject: RE: ORA-00959 -- error.
>Date: Thu, 11 Nov 2004 16:51:39 +0000
>
>Just wondering if you are trying to import the table containing the LOB
>column(s) into a locally managed tablespace (default in 9i), as that is not
>allowed. So the LOBDATA (and LOBINDEX) segments will have to go into a
>seperate dictionary managed tablespace.
>
>Regards
>Jannes
>
> >From: "Cameron Pam "
> ><oracledba-ezmlmshield-x38823248.[Email address protected]
> >To: "LazyDBA Discussion" <[Email address protected]
> >Subject: RE: ORA-00959 -- error.
> >Date: Thu, 11 Nov 2004 09:51:10 -0600
> >
> >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
> >
>
>
>
>
>--------
>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