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

Thread: exporting and importing indexes?

  1. #1
    Join Date
    Jan 2001
    Posts
    15

    Exclamation



    I am trying to export a schema's object from nt box(8.1.6) to
    Linux box(8.1.7). I am able to export the schema's objects as tables,stored proce
    cedures,function except the indexes,array time. As for the documentation, I have tried the option of setting INDEXES as Y to export and import the objects. But nothing is happening and the thing
    I could not understand there is no error logs reported in both export and
    import log files.

    Am I am missing something on exporting/Importing indexes along with other objects?
    I was using following statement.

    exp system/manager file=exp.dmp log=exp.log owner = schuser indexes = Y

    imp system/manager file=exp.dmp from=schuser to=linuxschuser indexes = Y
    log=imp.log

    Any suggestion.

    SKM


  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Thumbs up try this


    use "rows=Y"

    imp system/manager@*HOST* file=exp.dmp from=schuser to=linuxschuser indexes = Y ROWS=Y log=imp.log


    - Magnus


  3. #3
    Join Date
    Nov 2000
    Posts
    344
    is there anything in exp.log or imp.log?

    if not, you are probably not getting connected to the database.

    if you run these commands from a command prompt you should be able to see if exp or imp is doing anything, or just bombing. what is it showing you at the command prompt when you execute these commands?

  4. #4
    Join Date
    Jan 2001
    Posts
    15

    jdorlon,

    In exp.log file, I am seeing a lot of exporting statement.
    But I don't see any exporting statement for the indexes.
    Isn't that weird?

    SKM






Posting Permissions

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


Click Here to Expand Forum to Full Width