copying table from one schema to another

[NasirMunir]

is there a way of copying a table from one schema to another schema with oracle enterprise manager console? If not, how can I accomplish this

Thanks

[NasirMunir]

I have been able to resolve that with access. I created linked table in access, made updates and it did the trick of updating the oracle table as well.
I would still like to know some other way of doing that too. I am wondering, if that is possible through enterprise manager console ?

[Dave44]

It can be done from SQL_PLUS as follows, BUT pay attention to the last lines shown. I did this to show that the table constraints arent created this way so you would have to add them once the table is created.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
 
[151]dave2@ORADB> create table T1 (tab_id    number  not null primary key);
 
Table created.
 
Elapsed: 00:00:00.04
[151]dave2@ORADB> conn dave@oradb
Enter password: ********
Connected.
[151]dave@ORADB> create table T1 as select * from dave2.t1;
 
Table created.
 
Elapsed: 00:00:00.03
[151]dave@ORADB> desc t1
 Name                                                                           
 ---------------------------------------------------------------------------
 TAB_ID                                                                         
 
[151]dave@ORADB> insert into t1 select 1 from dual connect by level <= 5;
 
5 rows created.
 
Elapsed: 00:00:00.00
[151]dave@ORADB> select * from t1;
 
    TAB_ID
----------
         1
         1
         1
         1
         1
 
Elapsed: 00:00:00.00
[151]dave@ORADB> alter table t1 add constraint pk_t1 primary key (tab_id);
 
Table altered.