DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: error indexfile generation

  1. 07-14-2001, 05:21 PM #1
    shashikumar
    shashikumar is offline Junior Member
    Join Date
    Dec 2000
    Location
    Mumbai
    Posts
    38

    Red face

    hey friends
    I have got export dump file. from i want to generate a indexfile for realignment of the tables.But i am not getting the referencial integriety constraints of the tables.
    my oracle database is 8.0.6 on digital unix.

    please help me out


    i am not getting the foriegn key references


    [Edited by shashikumar on 07-14-2001 at 05:58 PM]
    Reply With Quote Reply With Quote
  2. 07-14-2001, 05:50 PM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    indexfile only generate create index XXXX huh what do u mean constraints?
    Reply With Quote Reply With Quote
  3. 07-15-2001, 04:08 AM #3
    rohitsn
    rohitsn is offline Advisor
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    From the export file enter the following command to get the indexfile generation


    imp sys file=export.dmp log=exp.log indexes=n rows=n
    constraints=n full=y indexfile=create.sql ignore=y

    The create.sql file will contain all the sql commands to create the tables,index and integrity commands.
    In case of any help please be free to ask me at rohitsn@altavista.com


    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width