Strange Import problem - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Strange Import problem

  1. #11
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Just as a sanity check to ensure that the dump file does indeed contain the table create statements this is what I would do.
    I don't think this will work because it's on windoz and your dump file may be to big to open but....

    copy the .dmp file to something else, do a more on it (in Windoz case open) and see if the table create statements are in it. Don't open the orginal .dmp file cause you'll mess it up. If they're in there but REM'ed out then you'll know you've done a indexfile= or something didn't go right with the export.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  2. #12
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    Since your export isnt that large, why not export using the parameter owner....owner=(your_scema,my_schema,...)

    and import using parameter...fromuser=your_schema touser=yourschema ...

    exporting full=y is really not necessary...why all the sys etc. tables?
    Able was I ere I saw Elba

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