Re: How to create ORACLE tables using data from a file?

From: Kathy Jou <kjou_at_us.oracle.com>
Date: 30 Jul 92 00:36:49 GMT
Message-ID: <1992Jul30.003649.29429_at_oracle.us.oracle.com>

In article <1992Jul28.213101.2345_at_ms.uky.edu> skaul_at_ms.uky.edu (Sanjay Kaul) writes:
>I have to create ORACLE DATABASES from user files.
>One file contains database description. So the CREATE TABLE command
>has to execute using a file.
>Another file contains raw data(tuples) to be inserted in the TABLE
>created above.
>
>Hence the database structure has to be created from the file and
>then this database has to be filled(with rows) using another file.
>

I would recommend SQ*Loader, which allows syntax for table creation in the control file. Take a look at the ORACLE RDBMS Utilities User's Guide.

Kathy Jou
Oracle Corporation

Received on Thu Jul 30 1992 - 02:36:49 CEST

This message: [ Message body ]
Next message: Larry W. Virden: "Re: FAQ? Defining a query page against multiple field/multiple table"
Previous message: Neil Greene: "SQL*Reportwriter scroll down?"
In reply to: Sanjay Kaul: "How to create ORACLE tables using data from a file?"
In reply to Sanjay Kaul: "How to create ORACLE tables using data from a file?"
Next in thread: Larry W. Virden: "Re: FAQ? Defining a query page against multiple field/multiple table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message