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
2 - Upgraded the Oracle Application Express to 3.2 as per the video at
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
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 : email@example.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.