APEX

Ok I made my database in 10G XE (local), and I made a web application. This was of course stored locally. It comprised of the usual forms, pages, links, login page, etc, and the database had the usual queries, tables, etc. When viewing this web app on XE, it worked fine. No errors (of course I had small teething problems but I fixed those, and the app was bug free).

However, I came to hosting the database and I decided to use HTMLDB as it seemed to do all I needed for a small site for my uni project. However, when I have the site up, and I click on customers (there is a report displayed then the option to create records), I get an Oracle error saying table or view does not exist. Obviously as I am in HTMLDB and not regular XE it makes sense I get this error, because if I look for tables in HTMLDB it's only got the demo tables. Furthermore, the tables I have made do not exist in sys or system either. The strange thing is that an SQL coursework I did a few months ago (all I had to do is make some SQL queries by code), the tables for that exist in HTMLDB - and those tables were created using commands.

So the solution is, and I cannot find a way to do this, how do I export all of my tables from XE into HTMLDB? The whole schema really (inc queries etc). I cannot find a way to do this. I also cannot create tables in the GUI of HTMLDB because when I click on create then tables, nothing comes up on my browser to make a table - the main workspace is blank.

When clicking customer or flights etc (the error in the report segment):

failed to parse SQL query:
ORA-00942: table or view does not exist

On making a record after clicking submit:

ORA-06550: line 1, column 31: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 1, column 7: PL/SQL: SQL Statement ignored
Error Unable to process row of table EMPLOYEE.

This was never a problem when my app was still local.