This content has been marked as final. Show 4 replies
Pl post details of OS and database versions on the source and target. Are you referring to using SQL Developer ? If so, there is a tutorial here
Also check the SQL Developer documentation - http://docs.oracle.com/cd/E25259_01/appdev.31/e24285/dialogs.htm#sthref686
the source db is 11g version and destination db is using Version 3.2.20.09 (express version)
how can i clone table with data to destination db. (both os is window platform)
Pl post exact database versions on the source and target - "11g" is a marketing label and there is no database version "3.2.20.09" - pl check with your DBA for exact versions. Importing and exporting is documented - http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_overview.htm#i1009203
It's also not clear what you want to do. At one point you say "clone database" and in your follow-up post "clone table".
Using either conventional or data pump export/import to clone a table or schema can be pretty easy. But cloning a database using those utilities is much more difficult. There are tonnes of things in the database that even a FULL exp/imp doesn't pick up on and move. I've posted a list of that in the MOS community.