Dear Peace 95,

Thank you for answering. You do'nt how how it to be like lost in jungle and finally see another human being.

Following is the exact steps i followed.

1 - Installed Oracle Database Express Edition (XE) Release 2 on my local PC with Windows XP Professional SP 3 supplying the password for SYS and SYSTEM as per the video at
http://www.mandsconsulting.com/oracle-xe-install-tutorial

2 - Upgraded the Oracle Application Express to 3.2 as per the video at
http://www.mandsconsulting.com/install-oracle-apex-32-on-xe-and-xp-pro-video-walkthrough-tutorial


Befor the upgrade the Orcale Database 10g Express Edition come with APEX 2.0 (& something) as it shows at the bottom on the screen once you log in as SYSTEM

After upgrade the same changes to Application Express 3.2.0.00.27

I can not use hosted account as I am not connected to the net all the time.

Now after every thing done, I log in as
Workplace : SYSTEM
User : SYSTEM
password : ***********

It takes me to the home page with Application Express 3.2.0.00.27 showing at the bottom right of the screen. Now as per the book

1 - Click utilities
2 - Clik Data load/unload
3 - Click load
4 - Click load spreedsheet data
5 - Change the load from to 'upload file (coma seperated and tab delimited' & NEXT
5 - Browse fo rthe file ORDERS.csv & NEXT
6 - it shows Schema "SYSTEM"
7 - I gaive the table name as "ORDERS" & NEXT
8 - Change the new primiray key to "ORDERS_PK" & click LOAD DATA

And i get

"ORA-20001: create_table error: ORA-20001: Excel load run ddl error: ORA-01003: no statement parsed"

As i said I am totally new to this and migrating from MS Access. However I am quite familiar with Relational Data model, Databsae Modeling, Database Design, SET theroy & Logic (Academeic & theory) but no experience with DBMS other than MS Access. Begginers knowledge with SQL.

My objective is to make a fully functional application for 50 users in an organization for ORDERS ENTRY & INVOICE Raising. The network is all Windows XP Professional SP3.

Just want to ge ahead and start studying the chapter 2. But since a week I am stuck here.

1 - I can log is SYS
2 - i can log is SYSTEM

through http://127.0.0.1:8080/apex

Do not know much about 'Run SQL command line".

What do i do? Do i create another USER loging in as SYSTEM and then try?

There is no network and other developers. I am doing every thing to produce a fully functional applications. But i can not seem to get through the 2nd chapter of the book.

Before i updated the Apex 2.0 to Apaex 3.2, i could see the user 'HR' but after update the 'HR' and its tables also disappeared.

I have upgraded to APEX 3.2 because that is what the book uses so i can follow along. How are you able to follow the book with you default APEX 2.0?

I also tried making a new user while loged in as SYSTEM

1 - Loged in as

workpace : SYSTEM
User : System
Password : **********

2 - Click Mange Application Express Users
3 - Click Create
4 - User name : Jawad
password : ***********
confirm password : **************
email : jawadasgharali@yahoo.com
Accessible Schema (null for all) : (left null)
Default Schema : SYSTEM
User is a develper : YES
User is a worspace administartor : Yes
Set Account availibility : Unlocked
Require chage of password on first use : No

So now i created a new user called Jawad who is a workpace administartor

I log out from SYSTEM and log in back as Jawad

Workspace : SYSTEM
User : Jawad
Password : *********

and now i do all the things again to upload the data and i get the same error message.

I think some to do with Workpace, Users, Schemas, and tablespace capcity. But i have no idea about them.

Will be much appreciated if you can state the exact step by step instructions on how you got going. I tried complete uninstall and re-install and it works fine with the default APEX 2.0, but there is much difference between APEX 2.0 and APex 3.2 and the book uses the PAEX 3.2.

Regards

Jawad