| Load of data from PROD into TEST for testing [message #336960] |
Tue, 29 July 2008 08:10  |
Olivia
Messages: 519
Registered: June 2008
|
Senior Member |
|
|
I have been asked to LOAD 3 months old production data from production database to test database.
As, I have no idea about how would I do that? Or whats the steps
required. I need to do that using dblink.
It would help me a lot if someone demonstrate with example.
Do I need to take care of any steps or need to know things like space before copying data to test environment?
Regards,
Oli
[Updated on: Tue, 29 July 2008 08:11] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: Load of data from PROD into TEST for testing [message #336978 is a reply to message #336960] |
Tue, 29 July 2008 09:15  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
As JOY_DIVISION previously stated, you have a two part problem
& repeating the requirements does not change anything.
1) Identify rows that are 3 months old or younger
2) Load data while maintaining data dependencies ( load parent rows before child rows).
Each is specific only to YOUR database & neither is simple to implement.
This task should keep you busy for the next month or so.
Enjoy!
[Updated on: Tue, 29 July 2008 09:15] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: Load of data from PROD into TEST for testing [message #337550 is a reply to message #336960] |
Thu, 31 July 2008 03:57 |
Olivia
Messages: 519
Registered: June 2008
|
Senior Member |
|
|
| Quote: |
I would say this is pretty much impossible unless every single table had a load_date column, or else you will have to write code to find all the table dependencies.
|
In reply,
Each table have a timestamp column.
My idea is to disable the contraints.But I think before that
I need to know these things:
1. What is the approximate size of the DB or the amount of data that needs to be loaded into SI? What are the size of the tables? How much would be the approximate
2. Is physical backup required for this?
3. Which option need to follow? dbLink or Import/Export? Wont Export be faster than dblink?
4. Load data while maintaining data dependencies ( load parent rows before child rows).Need to disable the contraints
[Updated on: Thu, 31 July 2008 03:58] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Load of data from PROD into TEST for testing [message #338120 is a reply to message #338116] |
Sun, 03 August 2008 16:37 |
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
|
Senior Member |
|
|
| Quote: | pablolee surprised the way u think about other profession ... Very Happy
|
I'm assuming that you mean professional rather than profession. I'm not having a dig at your English, I'm simply clarifying what I think you mean. I'm not sure why you are surprised. You make stupid comments and expect that nobody will bring you to book on it. I have just had a look at some of your more recent posts and barring but a very few, they constitute little more than plagiarism or completely wrong advice. In short, I do not consider you to be a professional.
| Quote: | You feel to be very arogant as DBA.
|
You think it is arrogant to expect that people who are dealing with something as complex as the administration of an Oracle database to have a level of intelligence that they are capable of reading a few words on a sheet of paper? I'm a little astounded that you (if you consider yourself a professional) would consider that to be arrogant. I consider myself to be an IT professional and YES, I have a problem with people that do not have the skillset required to perform the job for which they are being paid. The problem is that people come onto forums such as this, get handed information to them on a plate by people like yourself, who do not expect them to put any real effort into finding the info and as a result we get "DBAs" incapable of any real problem solving.
| Quote: | Well every one have rights to put their opinion on forum ... its upto u to handle.... Very Happy
|
What exactly is thej point of this comment. Just your usual drivel.
| Quote: | People get scared by seeing the size of documentation.
|
You've already said that, I still think that it is an idiotic statement.
| Quote: | Note:- Life is fast all need answers of their question....
|
Does that remove their responsibility from putting in a little of their own effort.
| Quote: | I already said for every thing, for most of question asked on orafaq u can give link from documentation...
|
Well, that is awfully generous of you. How about in future then, you start posting the link to the Oracle documentation on the official Oracle site rather than posting links to non official sites.
| Quote: | By the way i.... I do work with other technoligies also Razz and i do have other profession other than DBA jobs....
|
I like football and consider myself to be a pretty good defender, so what.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
(DBPITR)
(I can also put useless and meaningless smiley).