SetWholeKingdeeEAS DatabaseMove to another environment for development and testing:
BackupOracle Database: (you can also PL-SQL through external tools)
[Oracle @ rcno8 ~] $Sqlplus
SQL * Plus: Release 11.2.0.1.0 Production on Tue Nov 23 10:58:56 2010
Copyright (c) 1982,200 9, Oracle. All rights reserved.
Enter user-name:Conn/as sysdba
Enter password:
Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
Run the following command in the database:
Create directory kdbak as '/EASData/easbak'
InReadhatRun:(BackupRc0819Database)
Expdp system/kingdee @ // 127.0.0.1: 1521/orcl schemas = rc0819 directory = kdbak dumpfile = rc0819_20100928.dmp logfile = rc0819_20100928.log job_name = Login
++
Introduce backup in another environmentOracle Database (Clone the ERP system ):
Run the following command in the database:
SQL>
Create tablespace "EAS_D_RCTEST20101123_STANDARD" datafile '/oradata/EAS_D_RCTEST20101123_STANDARD.ORA 'size 2000 M;
Alter database datafile '/oradata/EAS_D_RCTEST20101123_STANDARD.ORA' autoextend on;
Create temporary tablespace "EAS_T_RCTEST20101123_STANDARD" tempfile '/oradata/EAS_T_RCTEST20101123_STANDARD.ORA 'size 500 M;
Alter database tempfile '/oradata/EAS_T_RCTEST20101123_STANDARD.ORA' autoextend on;
Create user RCTEST20101123 identified by kingdee default tablespace EAS_D_RCTEST20101123_STANDARD temporary tablespace EAS_T_RCTEST20101123_STANDARD;
Grant dba to RCTEST20101123;
InReadhatRun the following command: (introduce database files)
Impdp system/kingdee @ // 127.0.0.1: 1521/orcl directory = kdbak dumpfile = export logfile = export remap_schema = rc0819: RCTEST20101123 remap_tablespace = partition: partition, partition: Export job_name = partition;