Problem importing objects to different tablespace

From: George Hofilena <GHofilena_at_cnv.org>
Date: Tue, 27 Nov 2001 12:15:02 -0800
Message-ID: <F001.003CDF3F.20011127110519@fatcity.com>

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
--

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). Received on Tue Nov 27 2001 - 14:15:02 CST