--新建表空间和用户
create tablespace IUser datafile 'IUser.dbf' size 10m;
create temporary tablespace IUser_temp tempfile 'IUser_temp.dbf' size 10m;
create user C##iuser identified by iuser account unlock;
alter user C##iuser
default tablespace IUSER
temporary tablespace IUSER_TEMP;
--12C
alter user C##IUSER quota unlimited on IUSER;
grant connect,resource to C##iuser; --把connect,resource权限授权给新用户
grant dba to C##iuser; --把dba权限授权给新用户
--添加字段扩展表空间
alter database datafile 'D:\app\orcl\product\12.1.0\dbhome_1\database\IUSER.DBF' AUTOEXTEND ON NEXT 50 M MAXSIZE UNLIMITED;
--删除用户
drop user 用户名称 cascade;
--删除表空间,及对应的表空间文件也删除掉
drop tablespace IUser including contents and datafiles cascade constraint;
--删除用户,及级联关系也删除掉
drop user LYK cascade;
修改oracle 字段(需要变成小数点后2位)
ALTER TABLE "Andon_BasicData" MODIFY ("CT" NUMBER(10,2)) ;