OraFAQ Forum: SQL & PL/SQL » Method to take table backup

Home » SQL & PL/SQL » SQL & PL/SQL » Method to take table backup (Oracle 11g, Linux)

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

Method to take table backup [message #618582]

Mon, 14 July 2014 01:45

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi ,

I have a question in using CTAS command.

Which method to use when i am ask to take table backup .Say for example developers wants to run
some DML scripts on table and want to take that table backup.In this case which method to use for table backup?

1.CTAS -- (CREATE TABLE AS statement)
2.Datapump ( expdp/impdp)

Regards,
Srini

Report message to a moderator

Re: Method to take table backup [message #618588 is a reply to message #618582]

Mon, 14 July 2014 02:25

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Why did you post this 3 times in a minute?
Data Pump is the way, imo.

Report message to a moderator

Re: Method to take table backup [message #618591 is a reply to message #618588]

Mon, 14 July 2014 02:36

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi Michel,

Quote:

Why did you post this 3 times in a minute?

By mistake i posted it 3 times.Sorry for that.Actually after creating this new thread i clicked 'Quote' button
which is at bottom of the thread and found one more post is created with same question Sad

and some mistakes
i have done that created another post.All this made me to post 3 times. I will see to that this kind of mistakes
will never happen hereafter.

Quote:

Data Pump is the way, imo.

1.What is imo?
2.In which situation CTAS command is used ?

Regards,
Srini

[Updated on: Mon, 14 July 2014 02:37]

Report message to a moderator

Re: Method to take table backup [message #618597 is a reply to message #618591]

Mon, 14 July 2014 03:30

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Database admin wrote on Mon, 14 July 2014 13:06

1.What is imo?

In Michel's Opinion Razz

Quote:

2.In which situation CTAS command is used ?

When you quickly want to do a big DML operation and you don't care about the expense of rebuilding the indexes and don't worry about the referential integrity constraints.

Report message to a moderator

Re: Method to take table backup [message #618603 is a reply to message #618597]

Mon, 14 July 2014 03:52

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Lalit Kumar B wrote on Mon, 14 July 2014 09:30

Database admin wrote on Mon, 14 July 2014 13:06

1.What is imo?

In Michel's Opinion

More accurately - imo = in my opinion.
It's a standard acronym.

Report message to a moderator

Re: Method to take table backup [message #618628 is a reply to message #618603]

Mon, 14 July 2014 07:57

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Thank you all

Report message to a moderator

Previous Topic:	what does table.column = table.column(+) refer to
Next Topic:	Sql Query to see the sales between dates

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 23:43:41 CDT 2024