oracle如何查看外部表,如何使用外部表来查看tnsnames.ora内容

按照你的步骤，我试了下，没啥问题。

SQL> create directory tns as 'D:\oracle\product\10.2.0\db_1\network\ADMIN';

Directory created.

SQL> create table tns(

2      text varchar2(400))

3      organization external

4     (

5      type oracle_loader

6      default directory tns

7      access parameters (

8     records delimited by newline

9     )

10     location

11     ('tnsnames.ora')

12     ) reject limit unlimited;

Table created.

SQL> select * from tns where rownum<10;

TEXT

--------------------------------------------------------------------------------

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network

\admin\tnsnames.ora

# Generated by Oracle configuration tools.

BS =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.100.211)(PORT = 1521))

)

(CONNECT_DATA =

9 rows selected.

SQL> spool off;

注意：tnsnames.ora是我本机上的文件，库是我本机的库。