DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12
  1. #11
    Join Date
    Sep 2003
    over the hill and through the woods
    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
    Pretoria, Rep of South Africa
    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