Dear Peace 95,

Thank you very much for answering. You do not know how it is to be like lost in a jungle and find another human being. The jungle being the metaphor for stuyding the book. I have posted the same question on the OTN Application express forum as well as on the OTN Database 10g express edition forum with no results. Just views of hundreds and no reply.

http://forums.oracle.com/forums/thre...24117&tstart=0
http://forums.oracle.com/forums/thre...24058&tstart=0

As the book says I am migrating from MS Acccess to oracle. However I am well veresed in Relational Databse Theory (Academic) and its underlying maths (Set theory and logic) as well as Database modeling and design (theory) but do not have experience on any RDBMS other than MS Access. Also have novice famililarity with SQL.

That aside, I am now lost since one week with 10g. Here is what I did.

1 - Installed Oracle Database Express Edition (XE) Release 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

2 - Now I log in as
WORKSPACE : SYSTEM
USER NAME : SYSTEM
PASSWORD : ********

3 - Go to Utilities > Data Load/Unload > Load > Loadspreadsheet Data >
Change the Load from to upload file (comma seperated or tab delimited) NEXT
Browse for the file which is 'ORDERS', NEXT
Change the table name to 'ORDERS'
Change the primirary key column to ORDERS_ID - LOAD DATA

And than i get

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

Forigive me for my ignorance as I am a newbie. As far as I know, when I installed the Oracle Database 10g Express Edition, it also installs with Oracle Appplication Express 2.1.

I have read all the Orcle documentation for the upgarde as also as per the video I am able to upgrade to APPEX 3.2 with out any problems. The User account SYS and SYSTEm is the same with my password and I use them to log in. When upgraded, at the bottom, when you log in, the page says Application Express 3.200.some thing. So no problems there.

How are you able to folow the book with Apress 2.1. The reason I upgraded to APEX 3.2 is that, that is what the book uses to teach.

Also I can not use hosted APEX account as I am not always on the net. My aim is to learn making for example a complete working application for example for 20 to 50 users on a LAN. Just to learn how to give them a fully developed software for example for ORDERS and BILLING running on a WINDOWS XP network.

How to i go about setting the APEX 3.2 to be used with the book. The APEX 3.2 is veru different from APEX 2.1. I just want to lets, say make a new Workspace, A new USer, new Schema and start doing the excersises in the book.

I got so frustated, that I uninstalled every thing and reinstalled again. Now a new problem. When I try to upload data, NO SCHEMA is showing.

As i said, I am totally new to this and MS Access approach is very different from Oracle. But a week just to install oracle and not able to get beyond the first chapter?

Please if you have any suggestion I would greatly appreciate it. Some thing like step by step instructions. I know it's a lot to ask, but i have no options.

Regards

Jawad