We are planning to move the database server from server A to B. I got only one big partition table and couple of small tables. The big table has got 3 billien rows in it. I would like to know which is the best method to do this job.
What version of oracle you are running ? If its 8i+ and you are moving the database to same platform and patch level, you can use the trrasporatable tablespaces feature of oracle.
Follow this link for limitations
If the two servers are compatible (close OS's, same mount points/pathnames) you could shutdown the database on server a, do a full cold backup of the database and Oracle directories, then do a restore to server b. There are some less clean variations, depending on the differences between the servers, operational windows, etc.
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'