How to Export/Import Jeoms Rules.
Article ID: KB0093046
Updated On:
| Products | Versions |
|---|---|
| TIBCO Fulfillment Order Management | - |
| Not Applicable | - |
Description
Resolution:
sqlplus SYSTEM/password@SID
CREATE OR REPLACE DIRECTORY dmpdir AS '/home/oracle/jeoms';
GRANT READ,WRITE ON DIRECTORY dmpdir TO fomoms;
- With Oracle SO user
expdp system/password directory=dmpdir dumpfile=jeoms.dmp logfile=expschema.log TABLES=fomoms.RULE_HEADER,fomoms.RULE_UI_DETAILS
This will create jeoms.dmp in /home/oracle/jeoms
sqlplus SYSTEM/password@SID
CREATE OR REPLACE DIRECTORY dmpdir AS '/home/oracle/jeoms';
GRANT READ,WRITE ON DIRECTORY dmpdir TO fomoms;
- With Oracle SO user
impdp system/password TABLES=fomoms.RULE_HEADER,fomoms.RULE_UI_DETAILS directory=dmpdir dumpfile=jeoms.dmp logfile=impschema.log TABLE_EXISTS_ACTION=replace
EXPORT source database.
Create directory /home/oracle/jeoms
sqlplus SYSTEM/password@SID
CREATE OR REPLACE DIRECTORY dmpdir AS '/home/oracle/jeoms';
GRANT READ,WRITE ON DIRECTORY dmpdir TO fomoms;
- With Oracle SO user
expdp system/password directory=dmpdir dumpfile=jeoms.dmp logfile=expschema.log TABLES=fomoms.RULE_HEADER,fomoms.RULE_UI_DETAILS
This will create jeoms.dmp in /home/oracle/jeoms
IMPORT target database.
sqlplus SYSTEM/password@SID
CREATE OR REPLACE DIRECTORY dmpdir AS '/home/oracle/jeoms';
GRANT READ,WRITE ON DIRECTORY dmpdir TO fomoms;
- With Oracle SO user
impdp system/password TABLES=fomoms.RULE_HEADER,fomoms.RULE_UI_DETAILS directory=dmpdir dumpfile=jeoms.dmp logfile=impschema.log TABLE_EXISTS_ACTION=replace
Issue/Introduction
How to Export/Import Jeoms Rules.
Additional Information
Enhancement AF-6024: JEOMS Rules import/export
Feedback
Yes
No
Powered by
