OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Drop table

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

Drop table [message #657336]

Mon, 07 November 2016 02:23

shyam90
Messages: 3
Registered: November 2016

Junior Member

Suppose,I have dropped table and purged the recycle bin too. How can i get back table now?

Report message to a moderator

Re: Drop table [message #657337 is a reply to message #657336]

Mon, 07 November 2016 02:28

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

You'll need to recover from backup

Report message to a moderator

Re: Drop table [message #657338 is a reply to message #657337]

Mon, 07 November 2016 02:30

shyam90
Messages: 3
Registered: November 2016

Junior Member

How do we recover from backup? Just brief me up?

Report message to a moderator

Re: Drop table [message #657339 is a reply to message #657338]

Mon, 07 November 2016 02:46

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Restore the database somewhere else then export/import.

Report message to a moderator

Re: Drop table [message #657340 is a reply to message #657338]

Mon, 07 November 2016 02:46

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

Have you done any studying yet? Backup and restore of Oracle database is not something you can learn by asking a couple of questions on a forum. If it were that simple,no-one would need to employ a DBA. Start by reading this,
http://docs.oracle.com/database/121/BRADV/toc.htm

[Updated on: Mon, 07 November 2016 02:46]

Report message to a moderator

Re: Drop table [message #657347 is a reply to message #657340]

Mon, 07 November 2016 04:27

shyam90
Messages: 3
Registered: November 2016

Junior Member

Im fresher,this question was asked to me in interview. So thought of getting solution. Thank u

Report message to a moderator

Re: Drop table [message #657361 is a reply to message #657347]

Mon, 07 November 2016 08:24

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

Your interviewer was probably hoping that you would describe the 12c capability of automating the extraction of a table from a backup. Not difficult, but not something for novices either.

Report message to a moderator

Previous Topic:	How i can startup database without undo tablespace, without backup and noarchivlog
Next Topic:	creating tables using datafiles

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 00:59:22 CST 2025