Home | Ask Question | Add tip | My tips | Recent tips & tricks | Suggest a category | FAQ | Forums
|
grk.oracle : member's tip(s) |
|
| | Found 2 tips, Displaying 1 - 2 | |
|
|
|
| | Recover a dropped/deleted table from RMAN Backup
From 10g Onwards you can recover the dropped table from recyclebin, suppose the table is not available in recycle bin also flashback database in not enabled.
But you are having a recent RMAN backup containing that particular missing/deleted/dropped table.
you can recover the table by
1. create a duplicate database from production database ... | | More...
08/11/10 | | | | | | | | |
| | | Drop wrongly added Datafile in Tablespace(10gR2)
Unfortunately, you can't. Prior to Oracle Database 10g Release 2, your only clean option for removing a datafile is to drop the entire tablespace and then rebuild it without that particular file. If the tablespace contains data, you have to go through the time-consuming and laborious process of storing the ... | | 
More...
08/11/10 | | | | | | | | |
|
|
|
