本文共 2110 字，大约阅读时间需要 7 分钟。

   
    
    
        
     
SQLPlus?????
        
     
sqlplus /nolog
        
     
dba????
        
     
conn as sysdba;
                
     
???????
        
     
            
      
startup open
            
      
                
       
sql*loader??
                
       
????DBA
            
      
            
      
                
       
startup force
                
       
startup mount
                
       
                    
        
????
                    
        
?????
                
       
                
       
startup nomount
            
      
        
     
        
     
???????
        
     
            
      
alter database open
            
      
alter database mount
            
      
alter database nomount
            
      
alter system disable restricted session
            
      
alter system enable restricted session
            
      
alter database open read only
            
      
alter database open read write
        
     
        
     
?????
        
     
            
      
shutdown
            
      
shutdown immediate
            
      
shutdown transactional
            
      
shutdown abort
        
     
        
     
????
        
     
            
      
unlock account: alter user username account unlock;
            
      
??????: alter user username identified by password;
        
     
        
     
????
        
     
            
      
lsnrctl start
            
      
tnsping TEST
        
     
        
     
??????
        
     
SQL> select * from tab;
        
     
SQL> select name from v$datafile;
        
     
SQL> show parameter service;
        
     
SQL> select * from v$instance;
        
     
SQL> select name from v$database;
        
     
SQL> select * from dba_users;
        
     
SQL> select username,password from dba_users;
        
     
SQL> select * from v$pwfile_users;
        
     
SQL> select * from dba_ustats;
        
     
SQL> select * from user_sys_privs;
        
     
SQL> select * from user_role_privs;
        
     
SQL> select * from dba_sys_privs;
        
     
SQL> select * from v$version;
        
     
SQL> select * from user_views;
    
    
   
??: https://blog.51cto.com/morrowind/1713410

转载地址：http://oxpfk.baihongyu.com/