RE: Moving data to tablespace with new name
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <cemail_219@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 30 Jun 2005 16:34:07 +0200
if you make sure that the new (intended) destination tablespace is set as the
default tablespace for the user performing the import, and if you make sure the
importing user also has sufficient quota on that tablespace, import will create
the tables in the new tablespace.
in general, if the create table command fails during import because the
tablespace doesn't exist, the tables are crteated in the importing user's
default tablespace. so you just have to make sure that there is no tablespace in
the destination database with the original name. hope this helps,
kind regards,
Lex.
------------------------------------------------------------------
Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html
------------------------------------------------------------------
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of J. Dex
Sent: Thursday, June 30, 2005 16:17
To: oracle-l@xxxxxxxxxxxxx
Subject: Moving data to tablespace with new name
We want to move application data from one database to another. However, in the
new database we want to change the tablespace names so that they follow
a new naming convention. What is the easiest/most efficient way of doing
this?
If we initially change the tablespace names and then try and do an import, won't
the import fail?
Is there an easy way to create a new tablespace and copy everything into it and
then drop the old tablespace?
The original database is 8.1.7.4. We want to try and copy into one 8.1.7.4
database and one 9.2.0.6. They original database is on a seperate server than
the two new databases (the OS's are all Solaris).
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
--
//www.freelists.org/webpage/oracle-l
BEGIN:VCARD
VERSION:2.1
N:de Haan;Lex
FN:Lex de Haan
ORG:Natural Join B.V.
TEL;WORK;VOICE:+31.30.2515022
TEL;HOME;VOICE:+31.30.2518795
TEL;CELL;VOICE:+31.62.2955714
TEL;WORK;FAX:+31.30.2523366
ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583
SK=0D=0ANetherlands
URL;WORK:http://www.naturaljoin.nl
EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx
REV:20040224T160439Z
END:VCARD
Other related posts:
