Need help importing / exporting a schema

From: Blake McBride <blake_at_mcbride.name>
Date: Sun, 3 Jun 2007 04:01:37 GMT
Message-ID: <1364f8qtjac441a@news.supernews.com>

Greetings,

I have an application which runs under Postgres & MSSQL and I have a new client who wants to run it under Oracle 10g. I have no experience with Oracle but all I need is some basic abilities in order to port the app. The things I need to do are as follows:

1. Import a database schema and data from a text file containing SQL statements. The exact format of the SQL isn't important because I can change my program to output whatever syntax. So basically I am trying to import from a text file which looks like:

    CREATE TABLE abc (

    	...
	...

    )
    INSERT INTO abc .....

    and so on.

    I would also create primary keys, indexes, foreign keys, etc.

2. I need to be able to export the Oracle schema and/or data in a

    similar format as my import. Again, the exact (Oracle specific)     format is not important but is must be a text file with SQL     statements.

3. I'd like to be able to easily drop all the data, tables, indexes,

    foreign keys, etc. with a few simple commands in order to be able     to easily clear it all out and start over again. In other DB     systems I usually drop the whole database and recreate it with two     simple commands or clicks in the GUI.

In order to avoid the cost while testing my app locally I am attempting to avoid a purchase and just use Oracle's express edition (XE). Of course the client has an enterprise license or some such. I fear my difficulties may be associated with the limitations of the XE version. If so, what is the minimum version I can buy to get the type of facilities I am looking for?

Thanks for the help!

Blake McBride
blake_at_mcbride.name Received on Sat Jun 02 2007 - 23:01:37 CDT