I did a full dump of a 9i instance on a unix machine using (full=y) of the exp utility. Then I ftped the dump file locally, try to import it to a windows testing machine.
I created the new instance, and created all the tablespaces as the source instance. Then I did the full import. The log file does not report any error. However, I found none of the table contents are imported, log file reads ".. skip table table_name".
Further I used OEM, find of none of the users were created at the first place. I used "system" account to do both the imp/exp.
I really could not find where went wrong? Could anybody help? I am deeply confused, and need your suggestions.
Thanks.
I created the new instance, and created all the tablespaces as the source instance. Then I did the full import. The log file does not report any error. However, I found none of the table contents are imported, log file reads ".. skip table table_name".
Further I used OEM, find of none of the users were created at the first place. I used "system" account to do both the imp/exp.
I really could not find where went wrong? Could anybody help? I am deeply confused, and need your suggestions.
Thanks.