No TableData on Import
Posted on 2003-11-30
I added a larger harddrive to my NT server. The original instance (Schdora1) was exported to a .dmp file. I then stopped & disabled the Schdora1 Service, stopped & diabled the Listener, and installed a new Oracle 9i DB on the new drive. The new instance is call Schdora3 (because schdora2 failed, and it wouldn't let me reuse the name).
After much consternation and cursing about tnsnames.ora and listener.ora files I FINALLY connected to the new schdora3 Service.
I don't really understand this, but the schema "Schedule" is actually a user. I created my deveopment login of "BX", and the user "Schedule" after reading the IMP error message(s) several times.
answer all the default prompts which include "Import Table Data?" yes.
All the sequences, views, Procedures and Packages come in, and NONE OF THE TABLES or TABLEDATA!!!!!
Its even asks "Import Grants?" to which I answer "yes".
What the heck?