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

Home -> Community -> Usenet -> c.d.o.tools -> Re: How do you copy tables from a CD into a database?

Re: How do you copy tables from a CD into a database?

From: bullseye <bullseye35_at_deletethefunnies@excite.com>
Date: Fri, 01 Jun 2001 15:45:51 GMT
Message-ID: <PMOR6.26$QO5.54364@typhoon.nyc.rr.com>

"andrew_webby at hotmail" <spam_at_no.thanks.com> wrote in message news:991409248.3447.0.nnrp-13.c30bdde2_at_news.demon.co.uk...
> If it's a SQL script that is just to create, for example, demo tables
 (much
> along the lines of the SCOTT/TIGER EMP/DEPT deal), then you just do 'start
> d:\scripts\createit.sql'.
>
> Without knowing more about what these 'tables' are etc...
>
> Or SQL*Load perhaps if it's just data? Or perhaps you can *generate* SQL
> from the data file to row-by-row insert it using Perl for example.

I do not understand your question. I just started learning Oracle. The 8i reference manual comes with sample databases: Worker table, Customer table, Holiday tale,.... on and on. The tables are used in the manual to illustrate the subject matter. These same tables can also be found in the CD that accompanies the book.
I am aware that there is command , "@F:/.(filename)/......." that is used to copy files into SQL. What is that command? Received on Fri Jun 01 2001 - 10:45:51 CDT

Original text of this message

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