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 (likeReceived on Wed Jun 28 2000 - 00:53:49 CDT
![]() |
![]() |