Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Infor / Lawson Platforms
S3 Systems Administration
data refresh with Oracle 10g data pump
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
TomV
Past 24 Hours:
1
Prev. 24 Hours:
2
Overall:
5186
People Online:
Visitors:
332
Members:
0
Total:
332
Online Now:
New Topics
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Infor ION
ION vs IPA
2/29/2024 1:24 AM
We had a person new to Lawson and Infor go to Info
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
S3 Systems Administration
data refresh with Oracle 10g data pump
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Duane
Basic Member
Posts: 17
8/12/2009 8:20 PM
Suddenly our Oracle resources are very thin and we are trying to figure out how to refresh Lawson production data to test. We want to use the Oracle 10g data pump. Any tips or suggestions which may be Lawson specific? We are on 9.0.1 LSF and 9.0.1 Apps. Both test and prod databases are on the same server, along with test and prod environments.
Any input would be greatly appreciated.
Shasidhar Vemireddy
Basic Member
Posts: 14
8/18/2009 2:38 PM
Duane,
I am in the same boat as you. I have lot of DBa here and they recommended not to use Oracle 10g data pump. We were trying to use so that we could obfuscate data from prod to dev/test due to GLBA issues. The data pump in 11g is a much better option.
Travis Cox
Basic Member
Posts: 4
9/8/2009 6:52 PM
We just finished our re-implementation of LSF9.01 (went from 803 to 901 and changed HR and GL structures)
I used Oracle 10gR2 datapump to refresh the data on the test boxes over 200 times during the life of the project. (still use it, now that we are live, just not quite so often)
Our db is approx 250GB is size and the datapump finishes in approx 5 hours.
The 5 hours includes dumping the prod db and copying to the test server, and the datapump import etc. I dump all 3 schemas (gen,logan,prodline).
I have the whole process scripted and combined with some rsynch stuff to copy all the lawson code, print files, ldap stuff, was stuff to the dev server.
Happy to share
Duane
Basic Member
Posts: 17
9/16/2009 9:44 AM
Hi Travis - thanks for your feedback. Primarily, the DBA is interested in the Data Pump parameters used just to refresh the prodline data to our test database. I don't think he is using a dump and import strategy, rather a direct link export/import? Does this make sense? If you have time for me to introduce my DBA to you, maybe he can get a few pointers from you? Thanks!
You are not authorized to post a reply.