Shulou(Shulou.com)06/01 Report--

1.When-create a tablespace

Create tablespace cmdb_db datafile'\ home\ cmdb_11.dbf' size 100m autoextend on next 50m extent management local

2. Murray-build users

Create user cmdb_1023 identified by admin default tablespace cmdb_db

3.While-give permission

Grant connect,resource,dba to cmdb_db

4. Musi-Import data (executed in the command window)

Imp cmdb/admin file=/home/cmdb_henan.dmp fromuser=cmdb_L touser=cmdb

5.While-Export data

Exp cmdn/admin owner=cmdb file=/u01/app/oracle/cmdb_heinan.dmp

6.While-Delete tablespace

Drop tablespace CMDB_db including contents and datafiles

7.Musi-View tablespaces and file paths

Select tablespace_name,file_id,bytes/1024/1024,file_name from dba_data_files order by file_id

8.Mui-Delete the user and delete all data under the user

Drop user cmdb_perftests cascade

An error may be encountered in the deletion process: cannot drop a user that is currently connected prompts someone to connect to the user and cannot be deleted! At this point, use the following statement to delete the connection and then delete the user.

Select sid,serial# from v$session where username='CMDB_HLJ'; queries the SID,SERIAL# to which this database is connecting to CMDB_HLJ

Alter system kill session'54 Jing 5i; Kill connection 'SID,SERIAL'

Alter system kill session'98 select * from sys.dba_tablespaces;23'; Kill Link 'SID,SERIAL'

Alter system kill session '137 jinx; Kill Link' SID,SERIAL'

DROP USER CMDB_HLJ cascade; Delete user

9.When-View the tablespace name

Select * from sys.dba_tablespaces

10.Murray-exports the database, empty table does not export the problem (executed on the first export)

Select 'alter table' | | table_name | | 'allocate extent;' from user_tables where num_rows=0; copies the execution result of this statement, deletes all statements that do not begin with alter table, and executes the copied statement again. "Note: the connection user is the current user to execute"

Orcale database and monitoring start and stop operations (1) log in to the database as oracle, command: su-oracle (2) enter the Sqlplus console, command: sqlplus / nolog (3) log in as the system administrator, command: connect / as sysdba (4) start the database, command: startup (5) if the database is closed, command: shutdown immediate (6) exit the sqlplus console Command: exit (7) enter listener console, command: lsnrctl (8) start listener, command: start (9) exit listener console, command: exit (10) restart database end

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.