UNDO TABLESPACE

-
create undo  tablespace undo_ts datafile 'C:\oraclexe\oradata\xe\undo.dbf' size 1m;
ORA-01537: cannot add file 'C:\oraclexe\oradata\xe\undo.dbf' - file already part of database

create undo  tablespace undo_ts datafile 'C:\oraclexe\oradata\xe\undots.dbf' size 1m;

select name , file# from V$datafile

C:\ORACLEXE\ORADATA\XE\UNDOTS.DBF

Comments

Post a Comment

Popular posts from this blog

ADD DATAFILE TO USERDATA

-
alter  tablespace userdata add datafile 'C:\oraclexe\oradata\xe\userdata2.dbf' size 2m; Statement processed. 0.55 seconds SELECT TABLESPACE_NAME, FILE_NAME, FILE_ID FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'USERDATA'; USERDATA C:\ORACLEXE\ORADATA\XE\USERDATA1.DBF 5 USERDATA C:\ORACLEXE\ORADATA\XE\USERDATA2.DBF 7 SELECT  FILE_NAME, BLOCKS    FROM DBA_DATA_FILES where TABLESPACE_NAME = 'USERDATA'; FILE_NAME                                                       BLOCKS C:\ORACLEXE\ORADATA\XE\USERDATA1.DBF    256 C:\ORACLEXE\ORADATA\XE\USERDATA2.DBF    256
Read more

CREATE TABLESPACE

-
create tablespace userdata datafile 'C:\oraclexe\oradata\xe\data1.dbf' size 1m; Statement processed. 0.58 seconds select tablespace_name ,status ,contents  from dba_tablespaces; USERDATA ONLINE PERMANENT select tablespace_name ,status ,contents , block_size from dba_tablespaces; USERDATA ONLINE  PERMANENT    8192
Read more