Initially I had my Oracle 9i database on a Windows XP machine. I need to establish this particular database in Linux AS4 (Redhat) OS. I have configured the Oracle Database in the Linux machine. Can I import a dump from the previous Windows machine to this Linux machine and establish the database, or do I need to follow extra steps?
Since you are switching platforms (Windows to Linux), you will want to use exp and imp to perform the move. Perform a FULL export of your 9i database on Windows with exp. Then FTP the dump file (in BINARY mode!) to the Linux server. Precreate an empty database on the Linux server. Also precreate any tablespaces you'll need. Then perform a full import. It's as simple as that!
Dig Deeper on Oracle database administration
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.