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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
