OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Mion script

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Mion script [message #177166]

Tue, 13 June 2006 05:53

puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India

Member

Hi

I need to be migrated manually these tablespaces .

CTXD -->>APPS_TS_TX_DATA
IGID -->>APPS_TS_TX_DATA
XXPSD -->>APPS_TS_TX_DATA
XXHRSD -->>APPS_TS_TX_DATA
PORTALSYSDATA -->>APPS_TS_TX_DATA
TOGETHRSYSDATA -->>APPS_TS_TX_DATA
BAESSYSDATA -->>APPS_TS_TX_DATA
RECRUITMENTDATA -->>APPS_TS_TX_DATA
APPLSYSD -->>APPS_TS_TX_DATA

APPLSYSX -->>APPS_TS_TX_IDX
XXPSX -->>APPS_TS_TX_IDX
XXHRSX -->>APPS_TS_TX_IDX
PORTALSYSINDEX -->>APPS_TS_TX_IDX
TOGETHRSYSINDEX -->>APPS_TS_TX_IDX
BAESSYSINDEX -->>APPS_TS_TX_IDX
RECRUITMENTINDEX -->>APPS_TS_TX_IDX

Could anyone please send me migration script.
Please

Puneet

Report message to a moderator

Re: Mion script [message #177180 is a reply to message #177166]

Tue, 13 June 2006 06:28

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You need to be more clear. Provide OS/Oracle versions.
Migrate what?
Are you migrating from DMT to LMT
or
Just move the data from tablespace_A to tablespace_B with a different storage allocation/striped across different disks?
Then, move the underlying objects (tables/indexes) using

alter table table_name move new_tablespace_name;

You can spool the output and run the script or use some dynamic sql. You need to move the indexes also and rebuild the constraint.

Or for some other purpose if you just want to rename the tablespace, that can be done in 10g.

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
TEMP
USERS

SQL> alter tablespace users rename to another_users;

Tablespace altered.

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
TEMP
ANOTHER_USERS

Report message to a moderator

Previous Topic:	ORA-01031: insufficient privileges
Next Topic:	Export error: ORA-31626, ORA-31637, ORA-06512, ORA-39000, and ORA-04031

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:47:05 CDT 2024