| 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
Good to know that it really works, although I kind of have lost hope in my case here using 8.0.5. Maybe it is 8.0.5. I dunno. But thanks for the input anyway.
George
-----Original Message-----
Sent: Tuesday, November 27, 2001 4:07 PM
To: Multiple recipients of list ORACLE-L
George,
I've just tried the process as you've listed below (including dropping the exported table before importing again) and it worked fine without needing to precreate the table in the new tablespace. This is on Oracle 8.1.7. I noticed that the DDL in the export file included the old tablespace, but it was still created in the new tablespace OK. My first attempt failed, because I forgot to change the user's default tablespace to the new one before importing, but once that was done, it was successful.
FYI.
-arn
>>> GHofilena_at_cnv.org 28/11/2001 10:32:33 >>> This message has been scanned by MAILSweeper.
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 Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 - 19:13:40 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |