-- 12c创建用户
alter session set "_ORACLE_SCRIPT"=true;
create tablespace ZHWL_TBS datafile 'd:ZHWL_TBS.dbf' size 1M;
create user zhgyl_jhtb identified by zhgyl_jhtb default tablespace ZHWL_TBS;
GRANT ALL PRIVILEGES TO zhgyl_jhtb;
--drop user zhgyl_jhtb cascade;
SELECT FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE FROM dba_data_files;
-- 打开自动增长
ALTER DATABASE DATAFILE 'd:zhgyl_gkpt.dbf' AUTOEXTEND ON;
--每次自动增长200m
ALTER DATABASE DATAFILE 'd:zhgyl_gkpt.dbf' AUTOEXTEND ON NEXT 10M ;
-- 删除表空间
drop tablespace ZHGYL_JHTB including contents and datafiles;
oracle升级12c
最新推荐文章于 2022-09-05 17:52:25 发布