Database Backup and Recovery (MOSC)

MOSC Banner

is it possible to restore/recover a table to another tablespace's table?

edited Jun 15, 2015 11:08AM in Database Backup and Recovery (MOSC) 5 commentsAnswered ✓

Howdy all!  

OS: Linux 2.6.18+ x86_64 Oracle 11.2.0.3 in Archive Mode -

production instance currently tablespace.table : XXmode.mode_table1 [ the XXmode tablespace contains 50 other tables ]

I have validated full backups going back 30 days. There is now a requirement to compare the current XXmode.mode_table1 with the XXmode.mode_table1 from 28 days ago. FYI, the mode_table1 table is heavily updated. I was wondering if I could do the following::

create tablespace XXmode_Copy which is exactly like tablespace XXmode and create ONLY one (1) table, mode_table1 , not the other 48 tables. then use RMAN (?) to restore the archived XXmode.mode_table1 backup to the XXmode_Copy.mode_table1

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center