Notes on common Oracle commands and common oracle commands

Notes on common Oracle commands and common oracle commands

Login without a password: sys as sysdba

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

View the current database connection user: show user

View All Tables of the current data: select table_name from all_tables;

View Structure: for example, table structure: desc table1 -- in command window mode

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 have dba permissions, 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/manager @ TEST file = d: \ daochu. dmp full = y

Import: imp system/manager @ TEST file = d: \ daochu. dmp