Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Load .tcl file

User_DBUTXJul 23 2008 — edited Sep 25 2008
I am promoting my project using OMB*Plus for the first time.I am referring to:
http://www.rittmanmead.com/2007/03/13/promoting-from-dev-to-prod-using-ombplus/

When I try to deploy tables using script:
set tabList [ OMBLIST TABLES]

foreach tabName $tabList {
puts "deploying: $tabName"

OMBCREATE TRANSIENT
DEPLOYMENT_ACTION_PLAN 'DEPLOY_PLAN'
ADD ACTION 'TABLE_DEPLOY'
SET PROPERTIES (OPERATION)
VALUES ('REPLACE') SET REFERENCE TABLE
'$tabName'
OMBDEPLOY DEPLOYMENT_ACTION_PLAN 'DEPLOY_PLAN'
OMBDROP DEPLOYMENT_ACTION_PLAN 'DEPLOY_PLAN'
OMBCOMMIT
}
I get an error :
wrong # args:should be "OMBCREATE <object_type> <object_name> [detail syntax]"

And when I try to deploy mappings by using:
set mapList [ OMBLIST MAPPINGS ]

foreach mapName $mapList {
puts "deploying: $mapName"

OMBCREATE TRANSIENT DEPLOYMENT_ACTION_PLAN
'DEPLOY_PLAN'
ADD ACTION 'MAPPING_DEPLOY' SET
PROPERTIES (OPERATION)
VALUES ('CREATE') SET
REFERENCE MAPPING '$mapName'
OMBDEPLOY DEPLOYMENT_ACTION_PLAN 'DEPLOY_PLAN'
OMBDROP DEPLOYMENT_ACTION_PLAN 'DEPLOY_PLAN'
OMBCOMMIT
}
I again get an error

OMB00001: Encoutered <EOF> at line: 1,column:42. Was expecting one of: <QUOTED_STRING>.....

Please help...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 23 2008
Added on Jul 23 2008
9 comments
2,418 views