Home » RDBMS Server » Server Administration » Snapshot Tablespace
Snapshot Tablespace [message #174111] Fri, 26 May 2006 00:08 Go to next message
speaker
Messages: 30
Registered: April 2006
Member

i create a snapshot specifying the tablespace and index tablespace name.

CREATE SNAPSHOT SUBS_INFOa
TABLESPACE T_VOICD_small
USING INDEX TABLESPACE T_VOICD_small
REFRESH FAST
WITH PRIMARY KEY
as
SELECT subs_id, subs_is_active, subs_profile_last_update, subs_acnt_status FROM SUBS_INFO;

Then i am trying to reverse engineer the DDL of the snap shot using user_snapshots view

but i cannot see the Tablespace name related to the snapshot anywhere ..how do i get the tablespace name...
The base Table's Tablespace name is different.

I cant use metadata pkg bcos its V 8.1.7

Pls help

Report message to a moderator

Re: Snapshot Tablespace [message #174463 is a reply to message #174111] Mon, 29 May 2006 05:16 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
I think, you should query user_tables for table name SUBS_INFOa, as this snapshot will create a table with this name for holding data.

--Girish

Report message to a moderator

Previous Topic: Analyze Database
Next Topic: Solution required soon
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 19:59:57 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.