|
-
Thanks hrisky.
To make life more easier to Dominic follow this:
1. make a full backup.
login as dba
2. create 3 new tablespaces for APPS DATA and another
3 tablespace for APPS INDEX.
svrmgrl> create tablespace tbs_APPS1_dat datafile
'/u01/oradata/PRD/appsdat101.dbf' size 100M
autoextend on online;
svrmgrl> create tablespace tbs_APSS1_idx datafile
'/u03/oradata/PRD/appsidx101.dbf' size 80M
autoextend on online;
3. create three users to own the 3 new schema.
svrmgrl> create user apps1usr identified by apps1pwd
default tablespcae tbs_apps1_dat
temporary tablespace temp .......blah..
(don't forget to grant at least the select privs to apps1usr from original apps user)
login as apps1usr
4. create the table structure only.
svrmgrl> create table table1
as select * from oldapps1usr.table1
where rownum = 0;
Do this for all the tables owned by old apps users.
5. EXPORT the old apps user schema.
$ exp userid=oldapps1usr/oldapps1pwd buffer=81920 file=apps1.dmp grants=y constraints=y indexes=y rows=y
6. IMPORT to the new apps user schema
$ imp userid=apps1usr/apps1pwd buffer=81920 file=apps1.dmp grants=y indexes=y rows=y fromuser=oldapps1usr touser=apps1usr ignore=y
Then there goes your new 3 schemas with new tablespaces object resides.
Note: check for triggers that does not belong to the 3 users and yet dependent on old apps user. You have to recreate this triggers after you done the IMPORT process.
svrmgrl> select trigger_name from dba_triggers
where table_owner = 'OLDAPPSUSR' and owner <> 'OLDAPPSUSR';
You should do this before the above instructions.
Good luck.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|