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

Home -> Community -> Usenet -> c.d.o.server -> Re: exp and imp

Re: exp and imp

From: roblop <roblop_at_friko2.onet.pl>
Date: 2000/05/24
Message-ID: <FGLW4.23597$zA1.585910@news.tpnet.pl>#1/1 






>>

>1 make sure TABY is the default tablespace of user Y

>   alter user Y default tablespace TABY

>2 revoke unlimited tablespace /*privilege*/ from user Y

>3 make sure user Y has quota on TABY and doesn't have quota on TABX

>alter user y quota unlimited on TABY quota 0 on TABX

>4 Now run the import

>

>Hth,

>

>Sybrand Bakker, Oracle DBA





Thank yoy. This work.



Roblop
Received on Wed May 24 2000 - 00:00:00 CDT












Original text of this message













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