oracle的一些命令

alter user system identified by hr

sqlplus system/hr@orcl

sqlplus / as sysdba

C:/Documents and Settings/qianling>imp sysman/123456@orcl file=f:/6.5.120081124.dmp

create tablespace "OATEST" DATAFILE 'D:/dev/db/ORACLE/ORADATA/ORA92/LUNTAN.ora' SIZE 5M

 

另外system账户被锁定，也可以通过dba账户进行解锁：alter user "SYSTEM" ACCOUNT UNLOCK;

 

并且修改它的密码

alter user system identified by xxx

 

 

查看表空间名字
select distinct TABLESPACE_NAME from tabs  //但是查出来的仿佛不是我的？？
查看几个表空间
select count(distinct TABLESPACE_NAME) from tabs