SQL> create table test1 (a int);

Table created.

SQL> create table test2 (a int);

Table created.

SQL> drop table test2 purge;

Table dropped.

SQL> create table test2 (b int);

Table created.

SQL> create view test_v as select t1.a,t2.b from test1 t1,test2 t2;

View created.

SQL>

SQL> COL OWNER FORMAT A10
SQL> COL NAME FORMAT A10
SQL> L
  1* SELECT OWNER,NAME,TYPE,REFERENCED_OWNER,REFERENCED_NAME FROM DBA_DEPENDENCIES WHERE NAME='TEST_V'
SQL> /

OWNER      NAME       TYPE               REFERENCED_OWNER               REFERENCED_NAME
---------- ---------- ------------------ ------------------------------ ---------------------------
SYS        TEST_V     VIEW               SYS                            TEST2
SYS        TEST_V     VIEW               SYS                            TEST1

SQL>