oracle操作指令

 欢迎转载，转载时请注明出处和作者联系方式
文章出处：http://blog.csdn.net/shaojieli

作者联系方式：李少杰 <lishaojie@126.com>

 

//连接数据库
sqlplus "/ as sysdba"

 

//启动数据库
startup

 

//启动监听器
lsnrctl start

 

//获取监听器状态

lsnrctl status

 

//启动多实例

export ORACLE_SID=xxx

sqlplus "/ as sysdba"

startup

 

//启动后链接
conn sys/123456@orcl as sysdba

 

//查询表空间内的所有表名
//select table_name from tabs;

Select Table_Name, Tablespace_Name
  From Dba_Tables
 Where Tablespace_Name = 'POC';

//输出转至文件
spool xxx.log
xxxxxx
spool off

 

//查看所有表空间
select * from dba_data_files;

 

//删除用户
drop user smartgps cascade;

 

//删除表空间
drop tablespace SMARTGPS including contents and datafiles cascade constraints;

drop tablespace MCC_TAXI_IDX including contents and datafiles cascade constraints;

drop tablespace ASYN_LOG including contents and datafiles cascade constraints;

drop tablespace ASYN_LOG_IDX including contents and datafiles cascade constraints;

drop tablespace ASYN_POS including contents and datafiles cascade constraints;

drop tablespace ASYN_POS_IDX including contents and datafiles cascade constraints;