無密碼登陸：sys as sysdba
查看當前的所有數據庫：select */name from v$database;
查看當前數據庫連接用戶：show user
查看當前數據所有表：select table_name from all_tables;
查看結構：如表結構：desc table1 --需在命令窗口模式下
新建數據庫用戶：create user username identified by password授權：grant dba to username
更改數據庫用戶密碼：alter user username identified by password
查看數據庫裡面所有用戶，前提是你是有dba權限的帳號，如sys,system:select * from dba_users
查看你能管理的所有用戶:select * from all_users查看當前用戶信息 :select * from user_users
導出：exp system/manager@TEST file=d:\daochu.dmp full=y
導入：imp system/manager@TEST file=d:\daochu.dmp
