db.dobo.sk

SQL> desc dba_data_files

SQL> select FILE_NAME, TABLESPACE_NAME from dba_data_files;

////////////////////////////////////////////////////////

volne miesto v datafiloch

SQL> desc dba_free_space

SQL> select TABLESPACE_NAME from dba_free_space;

////////////////////////////////////////////////////////

ako nadefinovat autoextend pre datafile

SQL> alter database datafile <path to datafile> autoextend on maxsize <size>M;

///////////////////////////////////////////////////////

datafile recovery

SQL> alter datafile <path to datafile> offline;

SQL> recover datafile <path to datafile>;