RE: Problem importing objects to different tablespace

All the objects are dropped beforehand. The import is done on a clean slate. I just put in the ignore=y because that's what the docs suggested and I was half hoping it'll drive the "space quota exceeded..." error away :)

George

-----Original Message-----
Sent: Tuesday, November 27, 2001 12:30 PM To: Multiple recipients of list ORACLE-L

George Hofilena wrote:
>
> Guys,
>
> I'd appreciate any help that I could get.
>
> I was trying to import to another tablespace, same user. I hadn't had a
> need to do this in a while but thought this shouldn't be too difficult.
So
> I did what the manuals said:
>
> ran a user export
> set user's quota on old tablespace to 0
> granted unlimited quota to user on new tablespace
> revoke resource, unlimited tablespace privs from user
> make new tablespace default for user
>
> Then when I ran the import with ignore=y I got the error "space quota
> exceeded for tablespace <old tablespace>" for all create table commands.
> Bottom line is, it didn't import the tables.
> Reading the manuals and Metalink docs, the process looked really
> straightforward.
>
> Does anybody know of anything that I've missed?
>
> Thanks,
>
> George
>

Yes : a user cannot own two objects with the same name. The problem is with keeping everything in the same schema. You should have dropped all tables to be moved beforehand. Your message doesn't come from CREATE commands, but INSERT commands (you are aloso likely to have a number of duplicate rows if some of your tables had no unique index, PK or otherwise, defined).

-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:    +44  (0) 7050-696-449 
Performance Tools & Free Scripts
--------------------------------------------------------------
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--------------------------------------------------------------
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
-- 
Author: George Hofilena
  INET: GHofilena_at_cnv.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).