Sign in or 
Location: The Official Oracle Wiki
Discussion: Deploying tables in an OWB Expert
Category:
Discussion Forum /
General Discussion
Share this
Showing 3 posts
|
zoodaddy |
Deploying tables in an OWB Expert
Apr 1 2009, 2:09 PM EDT
Hi all - I wrote an OWB Expert that creates beautiful tables for our developers that takes a few input variables and then does its magic. But as it is, the users have to deploy the table after it's created, and I would like to include this step in the Expert to make this procedure even easier for the users. I looked in the documentation and I can't figure this out. Has anyone done this before? Can someone point me in the right direction? Ferrarist, I'm looking in your direction....... Do you find this valuable?
Keyword tags:
deploying tables
Expert
OWB
|
Ferrarist |
1. RE: Deploying tables in an OWB Expert
Apr 3 2009, 2:04 AM EDT
Hey Zoodaddy,Of course you can use OMBplus to do that for you. For example use this routine to deploy your tables. Of course you have to write the tcl to connect to you repository and change context to the correct module yourself. set tabList [OMBLIST TABLES] foreach tabName $tabList { puts "deploying: $tabName" OMBCREATE TRANSIENT DEPLOYMENT_ACTION_PLAN 'DEPLOY_TABLE_PLAN' ADD ACTION 'TABLE_DEPLOY' SET PROPERTIES (OPERATION) VALUES ('REPLACE') SET REFERENCE TABLE '$tabName' OMBDEPLOY DEPLOYMENT_ACTION_PLAN 'DEPLOY_TABLE_PLAN' OMBDROP DEPLOYMENT_ACTION_PLAN 'DEPLOY_TABLE_PLAN' OMBCOMMIT } This is an example of a TCL (ombplus) routine that reads all the tables into a variable called tabList and then deploys all the tables which names are read into the variable to your database. Regards, Rob 1 out of 1 found this valuable. Do you? |
|
zoodaddy |
2. RE: Deploying tables in an OWB Expert
Apr 29 2009, 2:19 PM EDT
Thanks Rob! Sorry about the late response to your reply, I thought I had clicked to watch the thread but I guess I didn't, and someone just told me today that you responded. I have the Tcl script to connect to the database, choose a module, and create the table in the module, but I couldn't figure out the deployment part. The documentation was not helpful. How/where did you learn all this stuff? Just trial and error, or could you actually decipher that OWB manual? Or an Oracle class? I'd love to learn more so I can automate some of the tasks we're currently performing by hand...
Do you find this valuable?
|
