Oracle系统命令

1.登陆sqlplus

  A.sqlplus test/test@rundb中@后边的部分就是针对不同数据库的连接;

  B.sqlplus user/pwd@host:port/oracle_sid;

  C. set ORACLE_SID=oracle_sid

      sqlplus /nolog;

      conn /as sysdba;

2.  drop user test cascade;

     create user test identified by test

     //default tablespace EDU_TB
     //temporary tablespace EDU_TEMP;

     grant connect,dba to test;

3.exp

 

4.imp