Home » RDBMS Server » Server Utilities » Backup Some table (Oracle 10g)
Backup Some table [message #654848] Tue, 16 August 2016 03:27 Go to next message
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 #654850 is a reply to message #654848] Tue, 16 August 2016 03:36 Go to previous messageGo to next message
John Watson
Messages: 7183
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

I do not understad your question. However, you probably need to study either Recovery Manager or Data Pimp,
http://docs.oracle.com/database/121/BRADV/toc.htm
http://docs.oracle.com/database/121/SUTIL/GUID-17FAE261-0972-4220-A2E4-44D479F519D4.htm#SUTIL100

Re: Backup Some table [message #654854 is a reply to message #654850] Tue, 16 August 2016 03:43 Go to previous messageGo to next message
rayrevan
Messages: 21
Registered: August 2016
Junior Member
Our database contain 1500++ table, we want to split some table (4-5 table as sample) and then backup it. I dont have any idea where should i move that table and how to backup that things.
Re: Backup Some table [message #654858 is a reply to message #654854] Tue, 16 August 2016 04:20 Go to previous messageGo to next message
Michel Cadot
Messages: 65252
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What do you mean by:
1/ "move that table"
2/ "things"

It'd be better if you provide an example of what you want to do.
I think export is the tool you need, but I'm not sure as your question is not really clear, I'm afraid.

Re: Backup Some table [message #654862 is a reply to message #654858] Tue, 16 August 2016 04:43 Go to previous messageGo to next message
Flyby
Messages: 181
Registered: March 2011
Location: Belgium
Senior Member
You could use datapump to export/import the specific table(s)
You could move the table to some tablespace and backup the tablespace.
Re: Backup Some table [message #654864 is a reply to message #654858] Tue, 16 August 2016 04:52 Go to previous messageGo to next message
rayrevan
Messages: 21
Registered: August 2016
Junior Member
1.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.
Re: Backup Some table [message #654868 is a reply to message #654864] Tue, 16 August 2016 05:41 Go to previous messageGo to next message
Michel Cadot
Messages: 65252
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Read the link I gave you.

Re: Backup Some table [message #654876 is a reply to message #654864] Tue, 16 August 2016 06:29 Go to previous message
EdStevens
Messages: 863
Registered: September 2013
Senior Member
rayrevan wrote on Tue, 16 August 2016 04:52
1.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.
Previous Topic: Import with EXCLUDE syntax was not working
Next Topic: Import ERROR
Goto Forum:
  


Current Time: Wed Dec 13 03:36:38 CST 2017

Total time taken to generate the page: 0.02277 seconds