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: Auto Datafile Creation - How to aktivate ?

Re: Auto Datafile Creation - How to aktivate ?

From: oracle noob <Armin.Kramer_at_gmail.com>
Date: 21 Aug 2006 00:12:40 -0700
Message-ID: <1156144360.146766.23860@b28g2000cwb.googlegroups.com> 







I want to create a new data file automatical, not extend an old one.



This is the DDL sql, we use



ALTER TABLESPACE "USERS" ADD DATAFILE '/oradata/xyz/users01.dbf' SIZE
4194304K REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE 4096M



The Datafile have to be smaler than 4,4 Gbyte.
Received on Mon Aug 21 2006 - 02:12:40 CDT












Original text of this message













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