No question at this time
DBA Top 10
1 M. Cadot 10900
2 B. Vroman 7000
3 A. Kavsek 5300
4 J. Schnackenberg 3200
5 P. Wisse 2800
6 J. Péran 2200
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
8 D. Dave 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48584
Total active users1393
Act. users last 24h4
Act. users last hour0
Registered user hits last week77
Registered user hits last month381
Go up

Recover big table
Next thread: A question about datapump
Prev thread: RFS process is not able to start on newly created physical standby database 12cr2

Message Score Author Date
Hi, This is an interview question. Could som...... Balaji M Nov 11, 2020, 09:53
The same way than small table. ... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Michel Cadot Nov 11, 2020, 12:08
The answer seems incorrect. Bcoz when I said the s...... Balaji M Nov 12, 2020, 06:25
And what did say the panel when you asked them i...... Michel Cadot Nov 12, 2020, 07:10
Actually, the answer was incorrect.So I didn't ask...... Balaji M Nov 12, 2020, 08:26
But maybe the board is wrong. The most importan...... Michel Cadot Nov 16, 2020, 12:24
Michel, They won't give answers to wrong answer...... Balaji M Nov 17, 2020, 05:31
Even if they won't give an answer they want you ...... Michel Cadot Nov 17, 2020, 06:59
Hi 2) How to recover a big table ? => Ask w...... Jill Salalila Dec 08, 2020, 18:30
Yes that's true. But the panel wasn't satisfied...... Balaji M Dec 09, 2020, 07:31
>> there must be another way to restore huge ta...... Jill Salalila Dec 09, 2020, 13:35

Follow up by mail Click here


Subject: Recover big table
Author: Balaji M, India
Date: Nov 11, 2020, 09:53, 117 days ago
Os info: Linux 6
Oracle info: Oracle 11g,12c
Message: Hi,

This is an interview question.

Could someone please explain how to recover big table in oracle. Say for eg table size is 3TB.

Regards,
Balaji
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Recover big table
Author: Michel Cadot, France
Date: Nov 11, 2020, 12:08, 117 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message:
The same way than small table.

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Recover big table
Author: Balaji M, India
Date: Nov 12, 2020, 06:25, 116 days ago
Message: The answer seems incorrect. Bcoz when I said the same answer, the panel said it is incorrect.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Recover big table
Author: Michel Cadot, France
Date: Nov 12, 2020, 07:10, 116 days ago
Message:
And what did say the panel when you asked them in what it is incorrect?

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Recover big table
Author: Balaji M, India
Date: Nov 12, 2020, 08:26, 116 days ago
Message: Actually, the answer was incorrect.So I didn't ask him anything.

Regards,
Balaji
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Recover big table
Author: Michel Cadot, France
Date: Nov 16, 2020, 12:24, 112 days ago
Message:
But maybe the board is wrong.
The most important point in an interview is NOT the answer, it is how you react to a stress as this is the main point in a DBA job.
If you don't ask what is wrong in an interview, the board will think you don't ask what is wrong in your DBA job and then you will not fulfill it.

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Recover big table
Author: Balaji M, India
Date: Nov 17, 2020, 05:31, 111 days ago
Message: Michel,

They won't give answers to wrong answer. They can only ask questions in an interview
and giving answers to wrong answer is not their job.

lets close this topic.

Regards,
Balaji.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Recover big table
Author: Michel Cadot, France
Date: Nov 17, 2020, 06:59, 111 days ago
Message:
Even if they won't give an answer they want you to ask.
You seem to not understand that answers are less important than behavior in a DBA interview.

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Recover big table
Author: Jill Salalila, Philippines
Date: Dec 08, 2020, 18:30, 90 days ago
Message: Hi

2) How to recover a big table ?

=> Ask when the table was dropped ?

=> If it is dropped very recently, try to check whether it is existing or not in recycle bin.

=> If not possible from Recycle bin, you need to restore from any existing backup only.

RMAN provides an opportunity to recover dropped table since 12c.

You have to answer this way..

Oracle never introduced any Rocket Science mechanism to recover big table .. same as tiny table .

Regards,
Jill …





Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Recover big table
Author: Balaji M, India
Date: Dec 09, 2020, 07:31, 89 days ago
Message: Yes that's true.

But the panel wasn't satisfied with my these answers.
So there must be another way to restore huge table.

Regards,
Balaji
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Recover big table
Author: Jill Salalila, Philippines
Date: Dec 09, 2020, 13:35, 89 days ago
Message:
>> there must be another way to restore huge table.

Really, Larry Elision does not know that another way
but you guys knew about that way ... Good Luck.


Regards,
Jill ...
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here