Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How do you copy tables from a CD into a database?
Just as you say:
@f:\etc...etc just means "run the script specified in sql*plus". It's the same as 'start f:\etc..etc'
Don't think of it as 'loading' or 'copying' the script. If it helps, try to think of it like running a batch file or shell script of SQL IN sql*plus.
"bullseye" <bullseye35_at_deletethefunnies@excite.com> wrote in message
news:PMOR6.26$QO5.54364_at_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 - 11:32:12 CDT
![]() |
![]() |