| Backup Some table [message #654848] |
Tue, 16 August 2016 03:27  |
 |
rayrevan
Messages: 21
Registered: August 2016
|
Junior Member |
|
|
Hi,
I got problem to backup some table (maybe 4-5), i dont know where i should move that table (tablespace or schema) and how to backup that table.
any suggestion?
Thank you
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Backup Some table [message #654876 is a reply to message #654864] |
Tue, 16 August 2016 06:29  |
 |
EdStevens
Messages: 1376
Registered: September 2013
|
Senior Member |
|
|
rayrevan wrote on Tue, 16 August 2016 04:521.move that table = move sample table(4-5 table) into tablespace, schema, or maybe new database. after i move that sample table, i should fully backup sample table using cold backup.But i dont know where i should move sample table(new tablespace, schema or database) and how to backup that sample table.
example :
In our database contain 1500 table, and we want to split master table into 3 parts (each parts contain 4-5 sample master table). i dont have any idea to do it.
Why do you keep assuming you need to "move" the table(s)? You also spoke of "splitting" the table(s). Exactly what do you mean by that and why do you think you need to do it?
Maybe you need to step back and explain the business need.
- Why do you want to back up just these select tables and not a full database backup?
- How do you see these table backups being used?
If you'd answer those question you'd get much better advice on how to achieve your business requirements.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
