Oracle full backup

Oracle full backup

1. export epmssit database backup; exp system/sysadmin @ hnepms file = d: \ datas \ epmssit_bak20100401.dmp owner = epmssit2. create epmsprd users and tablespaces; sqlplus "/as sysdba" create tablespace epmsprd datafile 'd: \ datas \ epmsprd. ora 'size 100 M; create user epmsprd identified by epmsprd default tablespace epmsprd; grant resource, connect to epmsprd; 3. import epmssit to the epmsprd user; imp system/sysadmin @ hnepms file = d: \ datas \ export fromuser = epmssit touser = epmsprd4. clear junk data in the epmsprd database; delete from xxxxxx; 5. backup epmsprd; exp system/sysadmin @ hnepms file = d: \ datas \ epmsprd_bak20100401.dmp owner = epmsprd

 

Note: oralce11g does not allocate table space when creating a new table to improve performance and save space. It is allocated only when the record is inserted for the first time, but the oracle11g and later versions will cause this problem and the earlier versions will not be used.

Alter system set deferred_segment_creation = false;

 

Modify the default parameters.