copy tables/views inside Oracle 10g

How I can copy tables/view from database to database inside Oracle 10g ?

Source database on server
Target database in client
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SujithData ArchitectCommented:
You can use any of the following methods
1. import/export
2. CREATE TABLE <table name> AS SELECT * FROM <table name>@<db link name>
Here you need to have a db link between your client database and the server database.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Naveen KumarProduction Manager / Application Support ManagerCommented:
also you can use sql*plus copy ( NOT a sql command ) command in the target client database as shown below :

sample example for the same is

SQL> copy from scott/tiger@ORCL92 -
     to scott/tiger@ORCL92-
     create new_emp 
     using select * from emp;

See the below links with detailed information on  the same :*Plus_FAQ#How_does_one_copy_data_from_one_database_to_another_in_SQL.2APlus.3F

also from 10g, you can use expdp/impdp ( export dump/import dump utilities ) which offer a lot of new features when compared to traditional export and import.
interbusAuthor Commented:
If I want to copy whole database from source to target
SujithData ArchitectCommented:
with option full=Y
interbusAuthor Commented:
Hello sujith80

This is a command or what ?
with option full=Y
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.