I tried this once by taking a full export on Unix and copying the export file to my Windows environment (via FTP in binary format). I created the database in 8.1.7 with the users that were in the Unix database. As well, I had created the tablespace by the same names, but when I imported I was partially able to import the database. The relations were not established between the tables, and also I am not able to delete this database as it asks me for a password for the internal account. I do not have the password for the internal account in my Unix database. Is there something missing in these steps?
Without specific error messages or more information, I cannot provide further assistance with the import problem you have encountered. I would suggest trying it again since it looks like you followed the correct procedure.
With respect to your problem where you are being asked for a password when connecting internal, I suspect the init.ora parameter REMOTE_LOGIN_PASSWORDFILE is set to either SHARED or EXCLUSIVE. From your problem description, it sounds like you are logging into the database remotely, i.e., from another server, which explains the prompt for a password. If so, log in to the server locally with a userid that belongs to the DBA group. OS authentication overrides password file authentication so you should not be asked for a password.
Dig Deeper on Oracle database export, import and migration
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.