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: Import Data and store them in a # tablespace

Re: Import Data and store them in a # tablespace

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Fri, 23 Apr 2004 06:56:00 +0200
Message-ID: <pc8h80phf0mr5ib3q2nmne9i0o4gidb2nq@4ax.com> 





On Thu, 22 Apr 2004 19:02:37 +0200, "Volker Hetzer"
<volker.hetzer_at_ieee.org> wrote:



>Sorry for this idiotic way but AFAIK that's the oracle recommended way.




It's not.


Just make sure the user doesn't have UNLIMITED TABLESPACE privilege,
has QUOTA on the target tablespace, 0 QUOTA on the original tablespace
and change his DEFAULT TABLESPACE.



That's all there is to it.



--
Sybrand Bakker, Senior Oracle DBA


Received on Thu Apr 22 2004 - 23:56:00 CDT












Original text of this message













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