OraFAQ Forum: Server Utilities » Backup Some table

Home » RDBMS Server » Server Utilities » Backup Some table (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Backup Some table [message #654850 is a reply to message #654848]

Tue, 16 August 2016 03:36

John Watson
Messages: 8978
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

Report message to a moderator

Re: Backup Some table [message #654854 is a reply to message #654850]

Tue, 16 August 2016 03:43

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.

Report message to a moderator

Re: Backup Some table [message #654858 is a reply to message #654854]

Tue, 16 August 2016 04:20

Michel Cadot
Messages: 68760
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Backup Some table [message #654862 is a reply to message #654858]

Tue, 16 August 2016 04:43

Flyby
Messages: 188
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.

Report message to a moderator

Re: Backup Some table [message #654864 is a reply to message #654858]

Tue, 16 August 2016 04:52

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.

Report message to a moderator

Re: Backup Some table [message #654868 is a reply to message #654864]

Tue, 16 August 2016 05:41

Michel Cadot
Messages: 68760
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Read the link I gave you.

Report message to a moderator

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: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.

Report message to a moderator

Previous Topic:	Import with EXCLUDE syntax was not working
Next Topic:	Import ERROR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 20 07:12:27 CDT 2025