This content has been marked as final. Show 6 replies
Kyle - Login as the Service Administrator (...pls/apex/apex_admin) and navigate to Home>Manage Service>Feature Configuration where you'll see a setting for "SQL Scripts Maximum Script Size in bytes".
Thanks for the response and sorry for the delay getting back to you. Just to let you know, I am a newbie to this environment. I made an assumption that when you said Service Administrator you meant System administrator?
I guess I basically do not understand how to log in as that role. I can certainly follow your breadcrumbs to get to the right area and make the change, it's just the logging in as that role that I am confused.
Thanks for helping me out.
Service Administrator/Site Administrator/Application Express Administrator -- all the same thing. Not the same as System Administrator though. Whoever is responsible for installing Application Express in the database you're using has the username and password to be able to do this. That person would have created the workspace you use as a developer, the workspace you login to when you want to upload the scripts you mentioned.
I'm having the same problem. I just installed Oracle Express on Windows XP and can't seem to find anyway to get to system configurations where I can change "SQL Scripts Maximum Script Size in bytes". I am trying to create a database using scripts sent to us.
I navigated to Home>Manage Service>Feature Configuration but I was unable to see a setting for "SQL Scripts Maximum Script Size in bytes".
If you have a chance, please let me know.
Thanks in advance,
Apparently another component that allows you to create workspaces has to be installed in order to change the maximum script size from the default setting.