Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> importing dmp on different tablespace

importing dmp on different tablespace

From: <faheemrao_at_my-deja.com>
Date: Fri, 08 Dec 2000 19:06:13 GMT
Message-ID: <90rbev$vdd$1@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. Received on Fri Dec 08 2000 - 13:06:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US