MySQL Forums
Forum List  »  Performance

Re: TableSpace
Posted by: lokesh kumar
Date: April 05, 2012 01:19AM

Hi Rick,

I have few questions while taking the backups of the data

Q1: If we have single tablespace do we have possibilities of taking up whole data backup?

Q2: If we have single tablespace do we have possibilities of taking up individual table data backup?

Q3: If we have multiple tablespaces do we have possibilities of taking up whole data backup?

Q4: If we have multiple tablespaces do we have possibilities of taking up individual table data backup?

Q5: Which one is better in performance
a) taking individual table backup
b) taking whole data backup

Please calrify me in this regard.
Thanks in advance,

Regards,
Lokesh Kumar

Options: ReplyQuote


Subject
Views
Written By
Posted
2328
April 03, 2012 12:36AM
916
April 03, 2012 07:37PM
1243
April 03, 2012 11:29PM
1383
April 04, 2012 09:51PM
909
April 05, 2012 12:58AM
Re: TableSpace
974
April 05, 2012 01:19AM
904
April 05, 2012 10:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.