Message-Id: <10717.125186@fatcity.com> From: "Holman, Rodney" Date: Thu, 21 Dec 2000 15:49:22 -0600 Subject: RE: TNS_ADMIN variable location :Unix/Nt On NT you set this in the registry at: \\HKEY_LOCAL_MACHINE\Software\Oracle Add a string named TNS_ADMIN and set the value to where you want your SQLNET.ORA and TNSNAMES.ORA located. Rodd -----Original Message----- From: Ravindra Basavaraja [mailto:ravindra@sentica.com] Sent: Thursday, December 21, 2000 03:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: TNS_ADMIN variable location :Unix/Nt that is a environment parameter to be set. on unix set that to point to the directory where the network files = are.set this in the oracle .profile file. $echo $TNS_ADMIN should point to the right directory ravindra -----Original Message----- Sent: Monday, December 18, 2000 5:56 PM To: Multiple recipients of list ORACLE-L On Mon, 18 Dec 2000, arif wrote: > Hi ALL, > > Can anyone let me know as to where the TNS_ADMIN variable is located. > > Many Thanks and Regards, > Arif Khan It is normally set to $ORACLE_HOME/network/admin, or on Windoze %ORACLE_HOME%\net80\admin > > Schoen Volker wrote: > > > Hi list, > > > > I have a costumer, which has a system tablespaces with 1.2 GB. = Default > > storage parameter fpr initial and next extent are 102400 KB. My question, > > how can I minimize and reorganize system tablespace, Full DB = export? Or is > > there another easier method? > > > > TIA > > > > Volker Sch=F6n > > E-Mail: mailto:v.schoen@inplan.de > > http://www.inplan.de > > > > -------- > > Think you know someone who can answer the above question? Forward = it to them! > > to unsubscribe, send a blank email to = oracledba-unsubscribe@LAZYDBA.com > > to subscribe send a blank email to oracledba-subscribe@LAZYDBA.com > > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > > Jared Still Certified Oracle DBA and Part Time Perl Evangelist ;) jkstill@teleport.com jared_still@enron.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: jared still INET: jkstill@teleport.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20 Author: Ravindra Basavaraja INET: ravindra@sentica.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may