Oracle Common Command Notes

Login without password: SYS as SYSDBA

View all current databases: select */name from V$database;

View current database connection User: Show user

View all tables for current data: Select table_name from All_tables;

View structure: Table structure: DESC table1-Required in command Window mode

New Database User: Create user username identified by password

Authorization: Grant DBA to username

Change database user password: Alter user username identified by password

View all users in the database, provided that you are an account with DBA authority, such as Sys,system:select * from Dba_users

View all users you can manage: SELECT * from All_users

View Current User information: SELECT * FROM User_users

Export:exp system/[email protected] file=d:\daochu.dmp full=y

Import:imp system/[email protected] file=d:\daochu.dmp

Oracle Common Command Notes