Oracle_零度笔记

--查询表空间
SELECT tablespace_name,
file_id,
file_name,
round(bytes / (1024 * 1024), 0) total_space
FROM dba_data_files
ORDER BY tablespace_name;

--创建表空间
CREATE TABLESPACE hsocrmbase DATAFILE 'd:kms01.DBF' SIZE 2048M
AUTOEXTEND ON NEXT 100M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K
SEGMENT SPACE MANAGEMENT AUTO;

 

--查询表的数据数量
select t.table_name,t.num_rows from user_tables t ORDER BY NUM_ROWS DESC;

 

--会闪数据

insert into test select * from test as of timestamp(systimestamp - interval '30' minute );