12 Nisan 2012 Perşembe

Tablespace'e Datafile Eklemek

CREATE TABLESPACE USERS DATAFILE
  'D:\ORACLE\PRODUCT\10.1.0\ORADATA\DB\USERS01.DBF' SIZE 7893760K AUTOEXTEND ON NEXT 256M MAXSIZE 32000M,
  'D:\ORACLE\PRODUCT\10.1.0\ORADATA\DB\USERS02.DBF' SIZE 2048M AUTOEXTEND ON NEXT 256M MAXSIZE 5120M
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

Hiç yorum yok:

Yorum Gönder