Yes!
That is eventually how I did get it imported correctly!
-----Original Message-----
Sent: Tuesday, April 15, 2003 6:59 AM
To: Multiple recipients of list ORACLE-L
I haven't had the joy(?) of working with LOBs so this question may be
totally off-base but can't you create the empty table, including the
LOB segment tablespace definition, where you want it and THEN import?
- "Deshpande, Kirti" <kirti.deshpande_at_verizon.com> wrote:
> Melissa,
>
> Not a bug. It is how it works, unfortunately.
>
> According the Utilities Guide:
> " By default, a table is imported into its original tablespace.
> If the tablespace no longer exists, or the user does not have
> sufficient quota in the tablespace, the system uses the default
> tablespace for that user, unless the table:
> Is partitioned
> Is a type table
> Contains LOB, VARRAY or OPAQUE type columns
> Has an index-organized table (IOT) overflow segment. "
>
> So, you are stuck with these LOBs, unless you can get a new export
> file after they correct the source. But for now you may have to let
> the import dump these tables (with LOBs) into the original tablespace
> and then move them out later..
>
> I had to deal with a similar case just last week.... with a Vendor
> supplied dump file containing tables with LOBs. I ended up creating
> the tablespaces they wanted...
>
> HTH,
>
> - Kirti
>
> -----Original Message-----
> Sent: Monday, April 14, 2003 10:04 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> The tables that didn't create all contain LOB's. The tables without
> LOBs created with no problems.
>
> CREATE TABLE ...........
> TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 4096 P"
> "CTVERSION 10 NOCACHE STORAGE(INITIAL 12288 NEXT 12288 MINEXTENTS 1
> MAXEXTE"
> "NTS 249 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL
> DEFAULT))"
> IMP-00003: ORACLE error 1950 encountered
> ORA-01950: no privileges on tablespace 'SYSTEM'
> IMP-00017: following statement failed with ORACLE error 1950:
>
> Some bug probably.
>
> -----Original Message-----
> Sent: Monday, April 14, 2003 9:52 PM
> To: 'ORACLE-L_at_fatcity.com'
>
>
> List,
>
> It's late, and I'm scratching my head on this.
>
> Oracle 9IR2 Sun Solaris
>
> I've got a dump file from some consultant DUHvelopers. All the
> tables were created in the system tablespace along with indexes
> etc....
>
> In the past, I've been able to just import into another users schema
> and the tables are created in the default tablespace. For some
> reason this export file is still looking for the system tablespace
> when trying to create the tables.
>
> What am I missing here?
>
> TIA
>
>
>
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Godlewski, Melissa
INET: Melissa.Godlewski_at_hq.doe.gov
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Apr 15 2003 - 08:58:36 CDT