Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help importing / exporting a schema

Re: Need help importing / exporting a schema

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 03 Jun 2007 04:33:58 GMT
Message-ID: <Wwr8i.399531$g24.4655@newsfe12.phx>


"Blake McBride" <blake_at_mcbride.name> wrote in news:1364f8qtjac441a_at_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:

$ sqlplus username/password
SQL> @textfile_with_SQL

>
>
> 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.
SQL> DROP USER TEST_SCHEMA cascade; Received on Sat Jun 02 2007 - 23:33:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US