| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Imp in a file
Hi,
Are you talking about the data or do you need the structure of
the tables/indexes.
In case you need the structure
imp userid<user> full=y grants=y indexes=y indexfile=<filename>
The "filename" created will give you the structure.
Imp utility will not give you the data in an file(ascii
format).
I hope i am not mistaken.
shreepad
From: ORACLE-L_at_fatcity.com AT INTERNET on 06/27/2000 07:25 PM
To: ORACLE-L_at_fatcity.com AT INTERNET_at_CCMAIL
cc: (bcc: Shreepad Vaidya/IN/ALLTELCORP)
Subject: Imp in a file
Hi,
I need to import the datas of an exported schema in a file
to work
on the datas. These datas are not online.
I know it is possible, but i cannot found (retrieve) the
syntax of
the command in the doc (ver 8.0.4).
And fortunately, i haven't a web access on my work
computer.
Thanks for help, if any one can give me the syntax.
Oracle version 8.0.5, on AIX.
Regards
P. Deverge
philippe.deverge_at_opt.nc
--
Author: DEVERGE Philippe
INET: Philippe.DEVERGE_at_opt.nc
Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
San Diego, California -- Public Internet access /
Mailing Lists
---------------------------------------------------------------
-----
To REMOVE yourself from this mailing list, send an E-Mail
message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You
may
also send the HELP command for other information (like
Received on Wed Jun 28 2000 - 00:53:49 CDT
![]() |
![]() |