If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

no buddy u r wrong,we do using DBLINKS but how to export using dblinks i dont know (accenture inteview question)

I had a database that I needed to migrate from Solaris to Linux. The customer used xml types as datatype for tables. As a result we could not get exp or expdp to work. We also weren't able to get transportable table spaces to work. As I understand it there is a process to change the endian on a transportable table space. I ended up creating a blank schema on the Linux server with the xsd types, which allowed me to use create table as select statements to create the tables with the correct data types. I then exported and imported the tables that had long and long raw. Finally I used exp rows=n to export the constraints and indexes. It took 12 hours but it worked. Ideally you want to use expdp with compression=all and as many channels as you can use. But even better than that is to have the same OS on both servers and to use an rman backup to setup a data guard standby on the new server, then activate it to make it the current prod server, then if needed run dbua to upgrade to a new version of Oracle.

I did something similar to upgrade and migrate a database from 32 bit Linux to 64 bit Linux. Including upgrading from 10.2.0.3 to 11.2.0.3 and converting the database to 64 bit, that migration to less than two hours.

So yes you can either have the tables existing and do insert into, or you can do create table as. You then need to create indexes, constraints, triggers and any other stored procedures. You just need to know what the dependencies are.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.