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
interbusAsked:
Who is Participating?
 
SujithConnect With a Mentor Data 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.

0
 
Naveen KumarConnect With a Mentor Production 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 :
http://www.oracleutilities.com/SQLPLus/copy.html
http://www.orafaq.com/wiki/SQL*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.
0
 
interbusAuthor Commented:
If I want to copy whole database from source to target
0
 
SujithData ArchitectCommented:
export/import
with option full=Y
0
 
interbusAuthor Commented:
Hello sujith80

This is a command or what ?
export/import
with option full=Y
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.