Application server - Urgent [message #167365] |
Wed, 12 April 2006 12:21 |
ashuj20
Messages: 12 Registered: October 2005 Location: new delhi
|
Junior Member |
|
|
Hi ,
What I'm trying to do is export our production data (approximately 100 gb)and import it into our TEST instance, replacing the data that is currently in there. The production system is Oracle DB version 9.2.0.3, with Oracle Apps version 11.5.9. The TEST system is Oracle DB version 9.2.0.3 with
Oracle Apps version 11.5.10.2.
I do not have any idea about oracle apps.
Firstly, can anyone please tell me, is there complex task involved in data migration. I mean, since the version of oracle apps are different, will it cause any problem if I migrate the data to test version.
Secondly, can you please give me reference to some sites or books or documents, where I can get some basic knowledge on orcale apps.
Regards
Ashish
|
|
|
|
Re: Application server - Urgent [message #167749 is a reply to message #167365] |
Sun, 16 April 2006 11:51 |
zeshanali76
Messages: 180 Registered: January 2006 Location: Pakistan
|
Senior Member |
|
|
Dear Friend,
It has a long but simple procedure.
Source Database:
1. select table_name space from v$tablespace;
Generate a query who should create ur tablepaces e.g.
select 'create tablespace '|| table_space ||' datafile '/abc/xyz/tablespace_name' .....
Copy the result and save it in tableSp.sql file
2. select ' create user ' || username || ' identified by ' || '"'password '"' default tablespace '|| tablespace name from dba_users order by created;
Save the result in tablespace.sql
<SQL queries u will have to refine ok>
3. select ' create role ' || rolename || ';' from dba_roles;
SAve the result in roles.sql
4. select username from dba_users order by created;
Save the result in listofusers.txt file
5. Take full export of the Database.
Target Database:
Ru tablespace.sql < Tablespaces created>
Run createusers.sql < Users Created >
Run Roles.sql
now make a batch <windows> / sh <UNIX/Solaris/Linux/HP-UX/AIX>
for i in `cat listofusers/txt`
echo Importing user $i..
imp userid=<user with imp_full_database privilages>/password file=<full database export dmp> fromuser=$i touser=$i ignore=Yes Grants=yes
Run this script/batch file and relax on ur chair and c how Ur database is smoothly migrating from One OS to New OS/One Version to new.
Enjoy my friends.
I would love to job in Oracle Singapore
Zeeshan Ali Awan
zesh76@msn.com
|
|
|