Skip to Main Content
Forums

APEX

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!

Running a Script in another Schema

Adennis-OracleDec 17 2008 — edited Jan 28 2009
Hi,

I have two schema's associated with my workspace, DEV and TEST.

I want to load some objects into the TEST schema, The scripts are larger than 32k so I have to upload the scripts rather than use the SQL Command Window.
When I run a script the objects are created in DEV - The original parsing schema.
I now want to change the parsing schema to TEST so the objects are created in that schema. Is there anyway of creating my object in TEST without prefixing all of the object names?

I cannot connect to the DB in any other way other than through APEX.
I don't have access to the internal APEX workspace to change the parsing schema

Thanks,
Adam
This post has been answered by 438381 on Dec 17 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 25 2009
Added on Dec 17 2008
#apex-discussions, #schema, #session
12 comments
2,385 views