Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> importing dmp on different tablespace
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
![]() |
![]() |