This content has been marked as final. Show 3 replies
select owner, application_id, alias, pages, workspace_id, workspace
order by application_id
That should give you some insight as to whether application_id 100 exists and its association with parsing schema
(aka owner) and workspace.
Remove the where clause and you can see all of your applications in the database.
Edited by: stevenewguy on May 21, 2012 8:17 AM
Just to add to this slightly old thread. Thanks for that SQL Steve I have the same problem when doing an instance
export as the OP and using your SQL I see that app 100 is the Oracle demo app. Can anyone throw any light on
this? I'm using a Developer Day vm.
Oh. I was using the wrong user to export, changing to system works fine ... walks away quickly looking sheepish ... :}