| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Problem importing objects to different tablespace
Funny because Oracle has explicitly stated that you can actually import a user's objects to it's new default tablespace as long as you make sure that the user doesn't have any quota or privs on the old tablespace.
George
-----Original Message-----
Sent: Tuesday, November 27, 2001 1:00 PM
To: Multiple recipients of list ORACLE-L
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).
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).
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 - 17:43:18 CST
 |
 |