| vikhardba |
Posted: Nov 14, 2007 06:43:05 AM |
Total Post: 86
Joined: Apr, 2007
|
Hi to One and All,
I would like to know the steps for schema refresh on linux platform. Hope you will provide me complete steps.
|
|
|
 vikhardba |
| Posted: Nov 14, 2007 06:55:10 AM |  |
|
Total Post: 86
Joined: Apr, 2007
|
Can you please check my steps . . . Also please let me know whether my steps are correct or not.
If possible please provide me schema refresh steps. I got the idea and implementing it in my system. However, would like to know the complete steps.
Ex:
1. Take backup at Dev ( you mean complete database backup, please clarify me on this )
2. drop objects at dev ( steps please .. i know but need them for confirmation )
3. Take exp of schema at Prod ( check am i correct or not ....
prod]$ exp file=pmc.dmp log=pmc.log owner=pmc rows=n
4. scp dump to dev server ( check this also... )
prod]$scp /u01/oradata/prod/pmc.dmp oradb22s:/u01/oradata/stg/.
5. Import ( steps . . . . please
dev]$imp file=pmc.dmp log=pmc.log fromuser=pmc touser=pmc
|
|
|
|
|
| Prabir |
| Posted: Nov 22, 2007 07:13:57 AM | |
|
Total Post: 3
Joined: Feb, 2006
|
Steps for Schema Refreshing:
1.Take datapump export of production DB.
2.Take dump of the schema want to refresh if required as sys or system.
3.Log into DB as sys or system.
4.Drop the user using cascade option
5.Drop tablespace dadicated to that user/schema
5.Create tablespace for the user/schema
6.Create user with default tablespace as created in step 5
7.Grant connect/resource priv. to the user or can grant DBA
8.Scp the dump file to local M/c.
9.Use datapump import using remap schema=prod_schemma:dev_schema and remap tablespace=prod_ts:dev_ts to import the dump file
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
