ORACLE 常用命令

<1> 创建用户

        a doc: sqlplus user/user@oradb (连接远程服务器需要实例名称)

        b 进入oracle 控制台

           SQL>create user xxxx identified by xxxx;

           SQL> 提示信息

           SQL>grant user xxxx to dba;

           SQL> 提示信息

           SQL>commit;

           SQL> 提示信息

        c 用户创建完毕

        d 切换用户

           SQL> connect to xxxx;      

           SQL> 提示信息

      e doc下已系统管理员身份进入

          ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

          在打了sqlplus后，要输入时，直接在用户名处输sys/密码 as sysdba即可

<2> 创建表空间

   CREATE TABLESPACE "ZC01D01"
      LOGGING
         DATAFILE 'D:..ORACLE..ORADATA..ZC01D01.ora' SIZE 100M EXTENT
         MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;
   CREATE TABLESPACE "ZC01I01"
      LOGGING
        DATAFILE 'D:..ORACLE..ORADATA..ZC01I01.ora' SIZE 100M EXTENT
        MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO ;
   CREATE USER "ZBTOWN"  PROFILE "DEFAULT"
      IDENTIFIED BY "ZBTOWN" DEFAULT TABLESPACE "USERS"
      ACCOUNT UNLOCK;
   GRANT UNLIMITED TABLESPACE TO "xxxx";
   GRANT "CONNECT" TO "ZBTOWN";
   GRANT "DBA" TO "xxxx";
   /

<3> 数据导入/导出

    a: import.bat

       imp system/system@oradb fromuser=xxxx  touser=xxxx file=...20071212.dmp
       pause

   b: export.bat

       exp system/system@oradb  file=...20071203.dmp owner=xxxx
       pause

<4> 可户端工具

       PL/SQL