Home » RDBMS Server » Server Administration » what is an Index file ?
what is an Index file ? [message #58157] Tue, 05 August 2003 07:40 Go to next message
sidd
Messages: 130
Registered: May 2003
Senior Member
my friend in my team was talking something to run Index file when our import wasn't successful.. can any one tell me what is an index file?
Re: what is an Index file ? [message #58158 is a reply to message #58157] Tue, 05 August 2003 07:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
it is the option in import to extract the ddl for the tables
mutation:/home/oracle/scr/ora >imp dbadmin file=dbadmin.dmp indexfile=script fromuser=dbadmin touser=dbadmin

Import: Release 9.2.0.1.0 - Production on Tue Aug 5 09:35:16 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Password:

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. . skipping table "A"

. . skipping table "B"

. . skipping table "BONUS"

. . skipping table "DEPT"

. . skipping table "DUM_DEPT"

. . skipping table "E"

. . skipping table "EMP"

. . skipping table "H"

. . skipping table "I"

. . skipping table "PLAN_TABLE"

. . skipping table "REPOSITORY"

. . skipping table "S"

. . skipping table "SALGRADE"

. . skipping table "TEST"

. . skipping table "TEST11"

. . skipping table "TEST23"

Import terminated successfully without warnings.
mutation:/home/oracle/scr/ora >cat script.sql

REM  CREATE TABLE "DBADMIN"."A" ("D" NUMBER) PCTFREE 10 PCTUSED 40
REM  INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST
REM  GROUPS 1) TABLESPACE "USERS" LOGGING NOCOMPRESS ;
REM  ... 0 rows
REM  CREATE TABLE "DBADMIN"."B" ("ONE" NUMBER, "THREE" NUMBER) PCTFREE 10
REM  PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1
REM  FREELIST GROUPS 1) TABLESPACE "USERS" LOGGING NOCOMPRESS ;
REM  ... 0 rows
REM  CREATE TABLE "DBADMIN"."BONUS" ("ENAME" VARCHAR2(10), "JOB"
REM  VARCHAR2(9), "SAL" NUMBER, "COMM" NUMBER) PCTFREE 10 PCTUSED 40
REM  INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST
REM  GROUPS 1) TABLESPACE "USERS" LOGGING NOCOMPRESS ;
REM  ... 0 rows
....
...
....
REM  ALTER TABLE "DBADMIN"."I" ADD FOREIGN KEY ("ID") REFERENCES "H"
REM  ("ID") DISABLE NOVALIDATE ;
mutation:/home/oracle/scr/ora >

Re: what is an Index file ? [message #58159 is a reply to message #58158] Tue, 05 August 2003 08:08 Go to previous messageGo to next message
sidd
Messages: 130
Registered: May 2003
Senior Member
so whats there in "indexfile=script" i mean how do i create this using export? please explain me more on this..thanks
Re: what is an Index file ? [message #58162 is a reply to message #58159] Tue, 05 August 2003 08:22 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
just do an regular export.
to view the contents of the exported file or to generate the ddl of the tables use this INDEXFILE option. since we cannot OPEN OR view THE .DMP FILE
we can make use of this option.

imp indexfile=script creates an script.sql which will contain the ddl for the objects.

Previous Topic: Partitioned table syntax question....gurus please look
Next Topic: Patch 8174
Goto Forum:
  


Current Time: Thu Dec 26 07:25:48 CST 2024