You wrote:
I have an oracle database in my local
machine (Oracle 8). I want to upload that
into my server on the net. Could you please
guide me how to do it.
Umm... Er... That is a pretty wide open question without much detail. And not obviously related to PHP. But I'll give it a try anyways.
If I am correctly interpreting your question, then you have a development ("local") Oracle database and a production ("server on the net") Oracle database. You want to copy table data, indexes, sequences, and so on, from the development database to the production database. I assume that you DO NOT want to have the (hopefully firewall protected) server access your local development database directly.
If you do not have Oracle8 installed on your "server on the net", then you will need to license and install Oracle8 on the machine. Once Oracle8 is installed on both machines, then a number of options are available.
IMPORTANT NOTE: Copying binary Oracle datafiles (examples: tablespaces, Re-Do logs, etc.) between systems is definitely not supported except under extremely limited situations. Don't try this at home. Only skilled Oracle DBAs who know the details of how Oracle operates dare to copy binary files between systems. Even then, they do so under highly controlled circumstances.
Now on to the more common ways to move data between Oracle databases without copying raw datafiles around. The following options were the first ones to come to mind:
1) Use Oracle's EXP/IMP utilities to export the user schema or individual tables, then import them into the other database. Good for any volume of data.
2) Create a database link, then do a CREATE AS or SQL*Plus COPY to duplicate the data between machines. Okay for large volumes of data.
3) Write some SQL to dump the table data out, then use SQL*Loader to bulk load it into the target database. Good for large volumes of data.
4) Do some SQL-writing-SQL coding to dump the table data out as SQL statements, then use SQL*Plus to recreate it in the target database. Good for small volumes of data, but not great for large volumes of data.
5) Use your favorite data management tool on a machine with access to both databases to copy the data across. Okay for most quantities of data.
6) Kludge together some PHP code together in place of the data management tool in #5 above. Probably only realistic for relatively small datasets. I had to get PHP into this discussion some way since this is a PHP support forum.
I hope this gets you started in the right direction.
-- Michael
Darkstreak Consulting
www.darkstreak.com
