Oracle 11g Linux set up table space user authorization database Import Export

Sqlplus

/as SYSDBA

--View DBF storage location
SELECT * from Dba_data_files; --View File location SELECT * from Dba_directories;

--New Table space
Create tablespace bp_oracle logging datafile '/u02/oradata/devdb/bp_oracle.dbf ' size 100m autoextend on next 50m maxsize 2 00m extent management Local;

--New user
Create user bp_oracle identified by bp_oracle default Tablespace bp_oracle;

--User Authorization
Grant Connect,resource to Bp_oracle; --The CMS system needs to increase grant create view to Bp_oracle views permissions


--Users can access Dump_dir for easy import and export operations
Grant Read,write on directory Dump_dir to Bp_oracle; --If no dump_dir can be established
Create directory Dump_dir as ' G:/oracle_dump_dir '; --View Directory select * from Dba_directories;

--Database Import 1: normal
IMPDP bp_oracle/bp_oracle Directory=dump_dir dumpfile=bp_oracle20120209.dmp

--Database Import 2: Mapping situation
IMPDP bp_oracle/bp_oracle directory=dump_dir dumpfile=ncp20120209.dmp remap_schema=ncp:bp_oracle remap_tablespace= Ncp:bp_oracle

--data export, can be with version
EXPDP bp_oracle/bp_oracle Directory=dump_dir dumpfile=bp_oracle.dmp version=10.2.0.1.0

--Remove Tablespace
Drop tablespace bp_oracle including CONTENTS and datafiles;

--delete the user, and execute the statement carefully, the Cascade deletes all objects under that user.
Drop user bp_oracle cascade;

--Modify User password
Alter user bp_oracle identified by bp_oracle;

--Export database with no version
EXPDP bp_oracle/bp_oracle schemas=bp_oracle dumpfile=bp_oracle20120221.dmp directory=dump_dir JOB_NAME=full

--Export Database with version
EXPDP bp_oracle/bp_oracle schemas=bp_oracle directory=dump_dir dumpfile=bp_oracle20120221.dmp version=10.2.0.1.0

--Export database with no version
EXPDP bp_oracle/bp_oracle schemas=bp_oracle dumpfile=bp_oracle20120221.dmp directory=dump_dir JOB_NAME=full

--Export Database with version
EXPDP bp_oracle/bp_oracle schemas=bp_oracle directory=dump_dir dumpfile=bp_oracle20120221.dmp version=10.2.0.1.0

--Export Data specify table name data
Exp NMSWXT_MHWZ/NMSWXT_MHWZ file=/home/oracle/dmp/nmswxt_mhwz_news_content.dmp tables=news_content

--Import data, with mapping relationship
Imp Nmswxt_mhzz/nmswxt_mhzz file=/home/oracle/dmp/nmswxt_mhwz_news_content.dmp fromuser=nmswxt_mhwz touser=nmswxt_ Mhzz

--Establishing materialized view authorization
GRANT CREATE materialized VIEW to NMSWXT_SW;

--timed task authorization
Grant create job to NMSWXT_SW;

#启动数据库

STARTUP #启动例程 Sqlplus/as SYSDBA

Lsnrctl Start #启用监听 default directory