home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!dtix!darwin.sura.net!mips!pacbell.com!pacbell!oracle!unrepliable!bounce
- From: kjou@us.oracle.com (Kathy Jou)
- Newsgroups: comp.databases.oracle
- Subject: Re: How to create ORACLE tables using data from a file?
- Message-ID: <1992Jul30.003649.29429@oracle.us.oracle.com>
- Date: 30 Jul 92 00:36:49 GMT
- References: <1992Jul28.213101.2345@ms.uky.edu>
- Sender: Kathy Jou
- Organization: Oracle Corporation, Redwood Shores CA 94065
- Lines: 18
- Nntp-Posting-Host: hqpyr1.us.oracle.com
- X-Disclaimer: This message was written by an unauthenticated user
- at Oracle Corporation. The opinions expressed are those
- of the user and not necessarily those of Oracle.
-
- In article <1992Jul28.213101.2345@ms.uky.edu> skaul@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
-
-