Skip to main content

funny short viagra jokes custom writing sites here how to write a book review on the kite runner descriptive essay shopping complex african american family essays source site thesis it examples go to site source follow site evaluating photo essays bayer levitra cheapest price cialis 20 mg two days in a row follow link social work case study format viagra works best empty stomach best academic website go site cheap school essay ghostwriters sites uk essay on terrorism and human rights go to link flecainide generico do viagra enter see url slip a man viagra sample college personal statement essay enter site If you just wanted to create/assign a different schema to a workspace in APEX, that is easy to do, and there are plenty of resources to find that answer. However, what happens when you want to create/assign a different schema to a workspace and delete the originally assigned schema?

Let’s create a workspace

Now to check the schema assignment and add a new one to AWESOME_WORKSPACE


Time to head to SQL Developer and delete the unwanted AWESOME_SCHEMA


That didn’t work, so let’s try to update the table

Ok, maybe we could update a different table


Great!  Now let’s try to remove AWESOME_SCHEMA again


The AWESOME_SCHEMA is removed from the workspace, but it still exists


One more delete statement







We do not take responsibility for any unintended or unwanted consequences in your instance of Oracle, Oracle APEX, or related products as a result of reading our blogs or following our guides.  Though the information is fully tested and generally safe to use, our lawyers really have a thing against admitting potential wrongdoing.  If it makes you feel any better, one time I convinced them that the insurance term “deductible” meant the amount you can deduct from your taxes at the end of the year.  They didn’t talk to me for 6 months afterwards, but I think deep down, they thought it was a great joke.