RE: Problem importing objects to different tablespace

From: Feng, Jun <jfeng_at_verisign.com>
Date: Tue, 27 Nov 2001 14:28:03 -0800
Message-ID: <F001.003CE137.20011127130021@fatcity.com>

The default tablespace is only used whenever there is no tablesapce parameter in the crate and alter table/index statements. Since the export always have tablespace parameter with the create table/index statement, your import method definitely will fail. You can change the tablespace for the segment by creating the segment in the desired tablesapce first, then import.

Jun

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

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

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Feng, Jun
INET: jfeng_at_verisign.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------