select * from dba_profiles where profile=‘DEFAULT’ and RESOURCE_NAME like ‘PASSWORD%’; 查看创建的数据库的密码有效期
alter profile default limit password_life_time unlimited; 修改为无限制
select tablespace_name,file_name,autoextensible from dba_data_files where tablespace_name =‘SDE’; 查询sde表空间是否自动扩展
alter database datafile ‘D:\APP\WU\PRODUCT\11.2.0\DBHOME_1\DATABASE\SDE’ autoextend on; 设置表空间自动扩展
alter database datafile ’表空间路径’ autoextend off; 关闭自动扩展
select ‘alter table ‘||table_name||’ allocate extent;’ from user_tables where num_rows=0; 空表也要备份