1.查询账号状态
SELECT USERNAME, ACCOUNT_STATUS FROM DBA_USERS;
解锁账号
ALTER USER scott ACCOUNT UNLOCK
2.创建表空间
CREATE TABLESPACE myspace DATAFILE 'D:\mydata\mydata.dbf' size 10M;
3.更改默认表空间
ALTER DATABASE DEFAULT TABLESPACE myspace;
4.更改表结构
))
5.查看当前账号
SELECT INSTANCE_NAME FROM V$INSTANCE
SELECT NAME FROM V$DATABASE