用户相关操作
create user scottuser identified by scottuser;
grant connect,resource to scottuser;
grant create view to scottuser;
grant create synonym to scottuser;
revoke connect,resource from scottuser;
revoke create view from scottuser;
revoke create synonym from scottuser;
drop user scottuser cascade;
alter user scottuser identified by 123456;
conn scottuser/123456;
alter user us account lock;
alter user us account unlock;
表空间相关操作
CREATE TABLESPACE DATE_CMIS DATAFILE 'D:/cmis/DATE_CMIS.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE 5G;
alter tablespace myspace add datafile 'D:mysp.ora' size 10M;
create user cmis identified by cmis default tablespace DATE_CMIS;
grant dba to cmis;
drop tablespace zfmi including contents and datafiles cascade onstraints;