14 Ekim 2014 Salı

WHICH TABLESPACE BELONGS TO WHICH DATAFILE?


It is possible to see in two ways;

1-)select *
    from dba_data_files;


2-)select df.name,ta.name
    from v$datafile df,v$tablespace ta
    where df.ts#=ta.ts#; 


Data dictionary stuffs.



Hiç yorum yok:

Yorum Gönder