Oracle Database Discussions

hi there,

I have create tablespace but when i queried database it is not showing its existence

here are steps which i used to create tablespace------


create tablespace ts_corrupt
datafile '/PGHProdDB/oradata/paceview/ts_corrupt01.dbf'
size 10m autoextend on next 5m
extent management local
segment space management auto
/

tablespace created.


create user usr_corrupt identified by usr_corrupt
default tablespace ts_corrupt
quota unlimited on ts_corrupt
/

User created.

grant connect , resource to usr_corrupt
/

Grant succeeded.

conn usr_corrupt/usr_corrupt
Connected.

create table t_corrupt as select * from all_objects
/

table created

but when i query to see the appropriate datafile

conn / as sysdba

SQL> select * from v$dbfile;

FILE#
----------
NAME
--------------------------------------------------------------------------------
5
/PGHProdDB/oradata/paceview/example01.dbf

4
/PGHProdDB/oradata/user00.dbf

3
/PGHProdDB/oradata/paceview/sysaux.dbf


FILE#
----------
NAME
--------------------------------------------------------------------------------
2
/PGHProdDB/oradata/paceview/undotbs1.dbf

1
/PGHProdDB/oradata/paceview/system.dbf


and run rman backup-------------




rman terget /

RMAN> backup incremental level 1 cumulative database;

Starting backup at 28-AUG-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=28 devtype=DISK
channel ORA_DISK_1: starting incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/PGHProdDB/oradata/paceview/system.dbf
input datafile fno=00003 name=/PGHProdDB/oradata/paceview/sysaux.dbf
input datafile fno=00002 name=/PGHProdDB/oradata/paceview/undotbs1.dbf
input datafile fno=00004 name=/PGHProdDB/oradata/user00.dbf
input datafile fno=00005 name=/PGHProdDB/oradata/paceview/example01.dbf
channel ORA_DISK_1: starting piece 1 at 28-AUG-12


it is not showing "t_corrupt" tablespace while taking backup


now problem is arising where is my newly created datafile ?

thanks

regards

Edited by: abdul_ora on Aug 29, 2012 11:08 AM