RE: Tablespaces
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 2 Jul 2004 11:55:20 -0400
I have not tested this in several versions, but in the past, as long as the
tablespace specified in the export did not exist or was not allowed for the
user during the import session, you could get it to try the default
tablespace for the user. I can't remember whether it's a flag or the default
behavior.
If that doesn't work any more, it shouldn't be much work to export each user
no rows and disect/convert the tablespace names with your favorite tool.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Wit Serdakovskij
Sent: Friday, July 02, 2004 11:44 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Tablespaces
Hello, Ganesh.Raja,
> Create the Users and assign them Default Tablespace and then Import the
> Tables into them. When the Tables are imported they will be Imported into
> the Default Tablespace.
>
> Better Still u can Move the Tables from One Tablespace to the Other and
> Rebuild the Indexes.
It's not true at all. The export file contains TABLESPACE clause of CREATE
TABLE statement.
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Computer Centre - NIIPL
> Sent: 02 July 2004 09:41
> To: Oracle Mailing List
> Subject: Tablespaces
>
>
> Dear All,
>
> In our test database we are having one tablespace. The tablespace contains
> all the tables for different users. ( 1200 Tables). We would like to have
a
> separate tablespace for each user in the real time database.If we use the
> exp/imp utility, the table will be created in same tablespace as of the
> original one. Is there any way to insert the tables in to the newly
created
> tablespaces while using imp utility.
>
> Please help us.
1. Get the list of statements for creation of all the tables (with
tablespace needed).
2. exp
3. imp ignore=y
--
wbr,
Wit.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
