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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Load data: Schema Must be Specified

200615Apr 30 2009 — edited Jul 28 2009
I've upgraded Application Express (from 2) to 3.2. It sits on XE on XP.

When I try to Load Data. It insists on a schema, but no schema is available in the drop down selection box. Yet under 'Manage Application Express Users' the default schema shows accurately.

What could be the problem? It won't let me upload data without a schmea, but won't let me select one.

Comments

60437
What is the name of the workspace and the name of the user you authenticate as? What schema or schemas are mapped to the workspace to which you have authenticated?

Scott
1 person found this helpful
200615
Thanks. I was trying with workspace of SYS. When I tried another workspace it was fine.
gabs
I have the same problem, but It's not resolved, I'm never logged inn as sys.
The name of the workspace name and the user name I am logged inn as is the same (MUTKB)

Is there a fix for this?
60437
See the above questions: What schema or schemas are mapped to the workspace to which you have authenticated?

What version of apex and what version/edition of the database?

Scott
gabs
The versions right now are:
Oracle Database 10g Express Edition Release 10.2.0.1.0
Apex v.3.2.0.00.27

This has been a problem since i upgraded from 2.x, works if I load data to an existing table, but not if I select "New Table".

Workspace: MUTKB
Schemas mapped to Workspace MUTKB: MUTKB
logged in as user: MUTKB

Thank you for any help on this,
Gabs
60437
Gabs,

When you go to Manage Application Express Users, do you see a default schema for the user MUTKB? If not, select one and apply changes.

Scott
gabs
Scott, thanks for helping.

The default schema for user MUTKB is MUTKB. Tried resaving the page just in case, but no luck..

.gabs

Edited by: gabs on Jul 16, 2009 1:31 AM
60437
Okay, we'll have to dig around a little:

connect as SYS

alter session set current_schema=apex_030200
/
select default_schema from wwv_flow_fnd_user where user_name='MUTKB' and security_group_id=(select provisioning_company_id from wwv_flow_companies where short_name='MUTKB')
/

Scott
gabs
Here goes:
alter session set current_schema=apex_030200;
alter session set succeeded.
select default_schema from wwv_flow_fnd_user where user_name='MUTKB' and security_group_id=(select provisioning_company_id from wwv_flow_companies where short_name='MUTKB');
DEFAULT_SCHEMA
------------------------------
MUTKB

1 rows selected

PS:
Just so you don't think I'm rude or anything, I'm traveling to Africa in 6 hours and I won't have internett access there. So I'm unable to follow up this thread for a weeks time.

Cheers, Gabs
60437
Gabs,

I think I've got it. Connect as SYS and

grant create table to MUTKB
/

Scott
gabs
sspadafo wrote:
Gabs,

I think I've got it. Connect as SYS and

grant create table to MUTKB
/

Scott
YES, that worked perfectly!
Thank you so much Scott, really really appreciate it !

Gabs.
1 - 11
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 25 2009
Added on Apr 30 2009
#apex-discussions
11 comments
1,385 views