I have database running on Solaris. One table contains 63000000 records. I want to take these records out into a text file then I have to load data in another Oracle Table. Please suggest me a optimum way. I don't want to make my source database heavy.
Please help me. Thanks in advance