Home » RDBMS Server » Server Administration » Load of data from PROD into TEST for testing (Oracle9i)
Load of data from PROD into TEST for testing [message #336960] Tue, 29 July 2008 08:10 Go to next message
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 #336966 is a reply to message #336960] Tue, 29 July 2008 08:16 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
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.

Just refresh the entire database from production, or clone it.
Re: Load of data from PROD into TEST for testing [message #336971 is a reply to message #336966] Tue, 29 July 2008 08:35 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
I WANT TO LOAD DATA ONLY
Re: Load of data from PROD into TEST for testing [message #336972 is a reply to message #336960] Tue, 29 July 2008 08:37 Go to previous messageGo to next message
BlackSwan
Messages: 25047
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above


You're On Your Own (YOYO)!
Re: Load of data from PROD into TEST for testing [message #336976 is a reply to message #336972] Tue, 29 July 2008 09:00 Go to previous messageGo to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
I want to load the data only.


Regards,
Oli
Re: Load of data from PROD into TEST for testing [message #336978 is a reply to message #336960] Tue, 29 July 2008 09:15 Go to previous messageGo to next message
BlackSwan
Messages: 25047
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 #337527 is a reply to message #336978] Thu, 31 July 2008 02:59 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
Why dont you go for clonning DB and then doing point in time recovery...Razz (DBPITR)

Hope you have all the previous backup of your DB ..Very Happy
Re: Load of data from PROD into TEST for testing [message #337550 is a reply to message #336960] Thu, 31 July 2008 03:57 Go to previous messageGo to next message
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 #337714 is a reply to message #337550] Thu, 31 July 2008 17:28 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
Olivia personally i don't like to give any link ....

but for resolution of your problem i will suggest you to see it

http://youngcow.net/doc/oracle10g/backup.102/b14192/flashptr006.htm
Re: Load of data from PROD into TEST for testing [message #337715 is a reply to message #336960] Thu, 31 July 2008 17:35 Go to previous messageGo to next message
BlackSwan
Messages: 25047
Registered: January 2009
Location: SoCal
Senior Member
http://youngcow.net/

WOW! Rather blatant copyright violation!
Re: Load of data from PROD into TEST for testing [message #337759 is a reply to message #337715] Fri, 01 August 2008 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Given his answer in http://www.orafaq.com/forum/mv/msg/122044/337540/102589/#msg_337540 it is obvious that copyright is his least concern.

@sunil_v_mishra, why not posting a link to documentation in Oracle site?

Regards
Michel
Re: Load of data from PROD into TEST for testing [message #338054 is a reply to message #337759] Sat, 02 August 2008 16:24 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
People those who ask question they do have access to documentation?

I hope they don't understand that ,,,, Very Happy
Re: Load of data from PROD into TEST for testing [message #338056 is a reply to message #338054] Sat, 02 August 2008 17:45 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Quote:
People those who ask question they do have access to documentation?

What?
Is it your intention to sound like Yoda?
Quote:
I hope they don't understand that ,
Well, I certainly didn't understand it.
Re: Load of data from PROD into TEST for testing [message #338067 is a reply to message #338054] Sat, 02 August 2008 23:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>I hope they don't understand that
Never before realized that just a copy/paste will add more explanation that is already portrayed in original docs.


Re: Load of data from PROD into TEST for testing [message #338113 is a reply to message #338067] Sun, 03 August 2008 13:26 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
People get scared by seeing the size of documentation... Very Happy.

when some one is in trouble they just need answer rather than big documentation Smile
Re: Load of data from PROD into TEST for testing [message #338114 is a reply to message #338113] Sun, 03 August 2008 13:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For this kind of question, it he is in trouble this is BECAUSE he did read the documentation. Very Happy Mad Laughing Cool Sad Surprised (I can also put useless and meaningless smiley).

Regards
Michel
Re: Load of data from PROD into TEST for testing [message #338115 is a reply to message #338113] Sun, 03 August 2008 14:47 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
sunil_v_mishra wrote on Sun, 03 August 2008 19:26
People get scared by seeing the size of documentation... Very Happy.


That statement is verging on idiotic. If you are intimidated by documentation then you have no place working with an Oracle database and should move onto something better suited to your sensitive nature such as Access ... or stacking shelves in a supermarket.
Quote:

when some one is in trouble they just need answer rather than big documentation Smile
And yet, your answer consisted of a link to documentation (plagiarised from the Oracle site to boot).
There simply is NO smiley that would convey what I would really like to say
Re: Load of data from PROD into TEST for testing [message #338116 is a reply to message #338115] Sun, 03 August 2008 15:06 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
pablolee surprised the way u think about other profession ... Very Happy
"something better suited to your sensitive nature such as Access ... or stacking shelves in a supermarket"

You feel to be very arogant as DBA...

Well every one have rights to put their opinion on forum ... its upto u to handle.... Very Happy

People get scared by seeing the size of documentation...

Note:- Life is fast all need answers of their question....

I already said for every thing, for most of question asked on orafaq u can give link from documentation...

By the way i.... I do work with other technoligies also Razz and i do have other profession other than DBA jobs....
Re: Load of data from PROD into TEST for testing [message #338120 is a reply to message #338116] Sun, 03 August 2008 16:37 Go to previous messageGo to next message
pablolee
Messages: 2834
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.
Re: Load of data from PROD into TEST for testing [message #338121 is a reply to message #338120] Sun, 03 August 2008 16:52 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
Pablolee u got hurted....Very Happy

By the way You are not here to decide who is professional or who is not i don't need certificate from you... if you feel were my answers are wrong ,,, please correct it on that issue ok good for the OP..

And please don't have to gabble on this issue any more....

Re: Load of data from PROD into TEST for testing [message #338122 is a reply to message #336960] Sun, 03 August 2008 16:54 Go to previous messageGo to next message
BlackSwan
Messages: 25047
Registered: January 2009
Location: SoCal
Senior Member
sunil_v_mishra

YOU should read & FOLLOW the Posting Guidelines!

http://www.orafaq.com/forum/t/88153/0/
The Posting Guidelines can be found at the URL above & provided to ensure you can find & access them.

[Updated on: Sun, 03 August 2008 17:49] by Moderator

Report message to a moderator

Re: Load of data from PROD into TEST for testing [message #387133 is a reply to message #338122] Wed, 18 February 2009 00:31 Go to previous messageGo to next message
Khan_4u
Messages: 5
Registered: February 2009
Location: UK
Junior Member
Would u like to tell me what is this error ORA-12638 I am not able to connect with SQL*PLUS
Re: Load of data from PROD into TEST for testing [message #387154 is a reply to message #336960] Wed, 18 February 2009 01:17 Go to previous messageGo to next message
BlackSwan
Messages: 25047
Registered: January 2009
Location: SoCal
Senior Member
>Would u like to tell me what is this error ORA-12638 I am not able to connect with SQL*PLUS
no
Re: Load of data from PROD into TEST for testing [message #387163 is a reply to message #387133] Wed, 18 February 2009 01:54 Go to previous message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12638: Credential retrieval failed
 *Cause:  The authentication service failed to retrieve the credentials of a
          user.
 *Action: Enable tracing to determine the exact error.

Regards
Michel
Previous Topic: xdb schema
Next Topic: Bugs 7244238 and 7171446 - Patch Download
Goto Forum:
  


Current Time: Wed Dec 07 14:44:11 CST 2016

Total time taken to generate the page: 0.09225 seconds