Oracle tablespace operations

Oracle tablespace operations
-- View the tablespace SELECT tablespace_name, file_id, file_name, round (bytes/(1024*1024), 0) | 'M' total_spaceFROM dba_data_filesORDER BY tablespace_name; -- create tablespace testlogging datafile '/data2/js/test_01.dbf' size 50 m autoextend on next 50 m maxsize 20480 m extent management local; -- New TABLESPACE data file ALTER tablespace testADDDATAFILE '/data2/js/test_02.dbf 'size 1024 mautoextend on next 256 m maxsize 32767 M; -- delete TABLESPACE drop tablespace WISDATA including contents and datafiles;