Home » SQL & PL/SQL » SQL & PL/SQL » Entries in Tnsnames.ora and Sqlnet.ora
Entries in Tnsnames.ora and Sqlnet.ora [message #214386] Tue, 16 January 2007 03:41 Go to next message
Messages: 222
Registered: January 2007
Location: Bangalore
Karma: 0
Senior Member
Anyone could help me in confguring Tnsnames.ora and sqlnet.ora.

I have installed oracle 8i.

instance is orcl
default userid/psw :scott/tiger
defualt port :1521

How to know the database name for defualt schema scott/tiger.

Any help really appreciated

Thanks in Adv

Re: Entries in Tnsnames.ora and Sqlnet.ora [message #214398 is a reply to message #214386] Tue, 16 January 2007 04:39 Go to previous message
Messages: 15
Registered: December 2006
Karma: 0
Junior Member
select sys.database_name from dual;
Previous Topic: how to refresh a materialzed view which refreshes on demand
Next Topic: function errored out as saying exp not an identifier
Goto Forum:

Current Time: Tue Aug 22 13:47:17 CDT 2017

Total time taken to generate the page: 0.01647 seconds