table migration

[crsdev]

hello all,
I am trying to migrate some tables along with PK,FK and indexes form one schma to another with a script.
Can some please point me to some resources or help, or suggest something.

Thanks for the help in advance.

 

[SantaMufasa]

CRSDEV,

The best method to migrate one or more tables, along with PK, FK, indexes (and all other constraints) is Oracle exp/imp/DataPump. The "fromuser=<schema> touser=<schema>" parameters are the schema-migration features of the "imp" utility.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Scunningham99]

you can also use:

alter table <table name> move tablespace <tablespace name>

you will need to rebuild indexes once table is moved:-

alter index <index name> rebuild tablespace <tablespace name>

Sy UK

 

[SantaMufasa]

I am trying to migrate some tables along with PK,FK and indexes from one schma to another

Sy, a MOVE action cannot/does not change schemas; at most it will change tablespace.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]