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: Moving a table to another tablespace

Re: Moving a table to another tablespace

From: Vimal Rai <vimal.rai_at_india.birlasoft.com>
Date: 4 Sep 2002 06:13:19 -0700
Message-ID: <d80ec6b7.0209040513.295d840d@posting.google.com> 






Follow th steps:



    
  
  1.   Take export of table.
  
  2.   Drop table.
  
  3.   Change user's defaut tablespace.
  
  4.   deny user access to previous tablespace by usiing alter user quota command.
  
  5.   import table with option ignore=y






Have a nice day,



Vimal
Received on Wed Sep 04 2002 - 08:13:19 CDT












Original text of this message













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