Re: importing dmp on different tablespace

hi

The import utility can be thought of as running creation scripts for each database object that is imported. Therefore it will effectively be running

create table foo(bar varchar2(20)) tablespace AA_T storage (whatever the storage clause was) on import. Hence your errors. The simple solution. Pre run your table creation scripts to create empty tables under schema b. THEN run the import with ignore=y. This will populate your tables correctly.

You do NOT want to create these tables in the system tablespace. They should go elsewhere.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
(BTW For Howard - A while ago I stated that I left system accounts using the
system tablespace. I have since found that you were right and the oracle
recommendation is to set all users except sys to use different
tablespaces. )
<faheemrao_at_my-deja.com> wrote in message news:90rbev$vdd$1_at_nnrp1.deja.com...


>

>

> I have  two schemas

> Schema AA default tablespace AA_T

> Schema BB default tablespace System ,no qauota on AA_T

>

> both exist on same database

> I am trying to import the dump of AA schema into the schema BB.

>

> but when I try to do that oracle gives me errot that no privilige on

>

> tabelspace AA_T

>

> now when I grant priviliges to schema BB on AA_T then it import the

> data on the  tablespace AA_T .

> I want to import that schema on system tableapce or any other than AA_T

>

> I am struc here.

>

> any help would be very appreciated.

>

> thanks in advanc

>

>

> Faheem Rao

>

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.