Check +ASM
SQL> select name, total_mb, free_mb from v$asm_diskgroup;
Check Disk
SQL> show parameter create
Add Tablespace
SQL> alter tablespace users add datafile size 1000m autoextend on next 500m maxsize 8000m;
Check Tablespace autoextend
SQL> desc dba_data_files;
SQL> select Tablespace_name, file_name, bytes/1024/1024 mbytes, AUTOEXTENSIBLE, MAXBYTES/1024/1024 maxbytes, INCREMENT_BY nextmb
from dba_data_files
0 comentários:
Post a Comment