Dear List,
I couldn't find this
dbms_support.start_trace_in_session(sid,serial#,TRUE,TRUE)
Platform WinNT Oracle 8.1.7
Pl let me know
venkat
--
On Mon, 24 Sep 2001 03:05:19
Christian Trassens wrote:
Execute as sys or dba user the package
dbms_system.set_ev(sid,serial#,10046,12,'');
Or with
Oracle has implemented an X$DUAL 'table' in
recent versions of Oracle, which is the target
for 'DUAL' when the database is not open.
Like (all) X$ table, this mapping into the
SGA contains an address, index, and
instance id as well as the data column(s).
It's just unfortunate that Orale
Hi,
I would like to exclude an arrange of characters.
there is for instance:
not in ('A','B','C','D','E'...);
Is there not perhaps something easier? ie:
not in ( A-Z, a-z) ;
Does anyone know of a function or some other more economical way of doing
this?
Many Regards
Denham
--
Please
Hi,
Is it possible to find out the actual number of locked rows?
For example:
SQL desc test
Name Null?Type
-
F NUMBER(38)
SQL select * from test;
F
--
1
1
1
try using
not between 'a' and 'z' and
not between 'A' and 'Z' ;
-Original Message-
Sent: Wednesday, September 26, 2001 8:45 AM
To: Multiple recipients of list ORACLE-L
Hi,
I would like to exclude an arrange of characters.
there is for instance:
not in
Try this
ASCII(your_char) NOT BETWEEN ASCII('A') AND ASCII('Z')
ASCII('A')-ASCII('Z') is an interval and ASCII('a')-ASCII('z') is another so
be careful
_
Iulian Ilies
mailto: [EMAIL PROTECTED]
mailto: [EMAIL PROTECTED]
-Original Message-
Sent: Wednesday,
Thanks Folks,
So far all the examples have worked wonderfully.
Thank You all
Denham Eva
-Original Message-
Sent: Wednesday, September 26, 2001 8:45 AM
To: Multiple recipients of list ORACLE-L
Hi,
I would like to exclude an arrange of characters.
there is for instance:
not in
Hi everyone
We introduced external authentication on windows 2000.
I had the following init.ora parameter set
REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE
OS_AUTHENT_PREFIX=
and i forgot to set REMOTE_OS_AUTHENT = true.
connect with a / didn't work (of course).
I searched on Metalink and found 2
Ooops, I meant to say that a the article I was responding to was
factually incorrect, not my own post :0)
g
-Original Message-
Sent: Tuesday, September 25, 2001 12:30 PM
To: Multiple recipients of list ORACLE-L
Hmm, quite a bit of this is factually incorrect, and may be based on a
Dear All,
We have an application that was performing very bad when we migrated a
remote database from 7.3.4.40 to 8.1.6.3.0.
SInce we do not have time to tune all queries issued by the application we
thought that stored outlines is the way to go.
The application connect tos the remote side
That is beacuase it is not DBMS_SUPPORT, it is DBMS_SYSTEM:
exec sys.dbms_system.set_sql_trace_in_session(sid,serial#,TRUE|FALSE);
HTH
Mark
-Original Message-
Subramanian
Sent: Wednesday, September 26, 2001 07:45
To: Multiple recipients of list ORACLE-L
Dear List,
I couldn't find
Nirmal,
Perhaps the replies re AlertView have answered your question. AFAICR it
requires FTP service to be running. You did not specify your Operating
System. Do you simply want to view the Alert logs and Trace files for the
various databases or be alerted if an error appears in Alert Log or
WOW!! What a typo!!
That should of course be *because*.. LOL..
Mark
-Original Message-
Sent: Wednesday, September 26, 2001 10:45
To: Multiple recipients of list ORACLE-L
That is beacuase it is not DBMS_SUPPORT, it is DBMS_SYSTEM:
exec
Dear List,
I have an Sql statement use start with and connect by
clause.
How can I tune this sql statement?
So it will take less time
Regards,
Ashraf Salaymeh
__
Do You Yahoo!?
Get email alerts NEW webcam video instant messaging with Yahoo!
Some comments and queries interspersed below.
From: Steven Lembark [EMAIL PROTECTED]
Date: Tue, 25 Sep 2001 09:18:05 -0500
Subject: Re: Physical access to servers for maintenance
Begin Snip
Simplest method would be to say no we don't need it now, what is the
pager number of someone we can use
Do they mean the Capitol, or the capital city?
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: OraStaff [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 6:45 PM
To: Multiple recipients of list
Thanks for reply, especialy to Barbara and Bruce.
I made some experiments:
I think, fragmentation plays no role (PERCENT_BLOCKS_COALESCED is mostly
100). Execution plan is the same on Win NT and Open VMS. Optimizer methods
choose and rule gives almost the same results.
Select from table FET$ (
Can you post the query so we can have a nosey at it??
Kev...
hit any user to continue
-Original Message-
Sent: 26 September 2001 12:20
To: Multiple recipients of list ORACLE-L
Dear List,
I have an Sql statement use start with and connect by
clause.
How can I tune this sql
Title: RE: Physical access to servers for maintenance
This doesn't work for NT machines,
and it with Unix you cannot install 8.1.6 without X access.
Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their
I do 99% of what I need from SSH as well, the only exception is hardware and
installs, which I have someone in the data center do.
Of course, under NT this is completely different.
Although Win2000 does have a funky Telnet.
Do not criticize someone until you walked a mile in their shoes, that
I think it comes with 8.0.4. I don't know exactly.
However I enclose it one copy.
Regards.
--- Mark Leith [EMAIL PROTECTED] wrote:
WOW!! What a typo!!
That should of course be *because*.. LOL..
Mark
-Original Message-
Sent: Wednesday, September 26, 2001 10:45
To: Multiple
Ohhh, it works!
All you need is ... ???
(Telnet server alias telnetd)
:-)))
JP
On Wed 26. September 2001 14:45, you wrote:
This doesn't work for NT machines, and it with Unix you cannot install
8.1.6 without X access.
Do not criticize someone until you walked a mile in their shoes, that
Title: RE: Physical access to servers for maintenance
OK, terminal services?
I agree that install is an exception. It's nearly impossible if you aren't sitting in front of the host.
-Original Message-
From: Christopher Spence [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, September
Do you have the same parameters in init.ora file?
Parameters like sort_are_size might be important for performace of such a
query.
What are waits during processing?
Ivo
-Original Message-
Sent: Wednesday, September 26, 2001 02:30 PM
To: Multiple recipients of list ORACLE-L
Thanks for
Title: RE: Physical access to servers for maintenance
Are
you talking NT only or install in general? On unix all you need is a
decent
X-windows package for your PC (Exceed, ChameleonX, Reflection X?,
etc).
I've
been here 3 years, installed at least 30 new systems and have
never
been
in
The controlfiles have to be a backup controlfile from
the source database, as the one you create with:
alter database backup controlfile to '.'
Regards.
--- Seema Singh [EMAIL PROTECTED] wrote:
I did.
in initCLONE.ora file
control_files = Name of control file would be new
name or
8.1.6 and higher you must use the interactive installer, it will not work
through telnet. As far as I have seen, it is the same for 9i as well,
unless I missed the documents on a new character based installer.
Unless something has changed recently.
Do not criticize someone until you walked a
If you are interested I found the answer on metalink:
select dbms_utility.port_string from dual;
Ivo
-Original Message-
Sent: Wednesday, September 26, 2001 02:09 PM
To: '[EMAIL PROTECTED]'
Hello
how is it possible in PLSQL to decide on which operating system (NT/LINUX)is
server
It was probably configured not to permit remote access. You don't need
sqlnet.ora, but it's useful if you want to use authentication (for
example, on an NT network).
Cheers,
g
-Original Message-
Sent: Tuesday, September 25, 2001 8:30 PM
To: Multiple recipients of list ORACLE-L
I am
...
w number;
...
x := get_window_property(my_win, width);
...
What's wrong with this code. I get the message '...ORA-06502...'
I check the return value of get_window_property and it's a varchar2 value
like '400,000'
Oracle itself has in help an example like this a number variable is assigned
If I wish to do work on a database logging in to server itself and want to
prevent users from accessing the system via network is there another way to
do this if I don't want to use the enable restricted session
functionality. I'm thinking there's probably a neat way to utiltise the
listener
If you were to choose 10 questions to evaluate the competency of a DBA what
would they be given that the result would be their competence would be rated
as of the following:
- TERRIBLE (I would not let them within 100 miles of a database)
- FAIR (I'd show them some basic admin, but do
Does anyone else keep getting this message?
K.
---
[EMAIL PROTECTED] - no such user here.
Hi,
No such user found.Please check the Mail ID.
Regards
Sys Admin Team
: Message contains [1] file attachments
DISCLAIMER: This email is bound by the terms and conditions
Thank you for the answer. Do you have sample program?
From: Jacques Kilchoer <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: [Q] privilege allow user kill session???
Date: Tue, 25 Sep 2001 14:55:34 -0800
Write a
Wondering what folk out there do to manage disk space usage by tablespaces.
Is it common/bad practice to have MAXSIZE unlimited and/or MAX_EXENTS set to
a value which if reached would be larger than disk capacity and therefore
regular observation of space is required, or is there a better way to
Sean,
How about creating an admin listener (admin_listener for example) that is
only defined in your own listner.ora file on your desktop PC, and not in the
users listener.ora files. When you want to restrict them from access, simply
shut down their listener, whilst keeping your own open?
This
Hi,
You can always check for the location of the datafiles.
Their location on nt should start with {A-Z}:\ and can be evaluated
through a substring command or something
Jack
Libal, Ivo [EMAIL PROTECTED]@fatcity.com on 26-09-2001
15:10:23
Please respond to [EMAIL PROTECTED]
Sent by:
How about trying one, build an exception, and on exception try the other ?
HTH, Remco
-Oorspronkelijk bericht-
Van: Libal, Ivo [mailto:[EMAIL PROTECTED]]
Verzonden: woensdag 26 september 2001 15:10
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Platform
Hello
how is it possible
Joe,
I spoke to an
Oracle employee about this recently (in past month). Since we utilize Names
servers extensively,I would hate to redo entire infrastructure any time
soon. Basically, I was told that Names will NOT go away any time soon, if at
all. The idea to move to LDAP is great, but I
Hi sean,
My db is oracle816 on WinNT4.
Acutally, i want to know how to access alert/trace files from the remote
oracle server. Is the DBA should
share access to the directory(background_dump_dest) for the remote
adminstrator?
In other way, i simply want to view the alert logs and trace files
Hi,
If U logon to the database server itself you can just stop the listener and
nobody can logon through the tns connection. You can than set the oracle
sid and logon using sqlplus username/password.
If you want to use tns connection yourself you can set different temporary
portnumbers and
Not so. I have never installed using the host. We only have text
console terminals attached to our host boxes, so we can't do an X install
on the host. Have your SA or data center person copy the cd's to a place
on the server and run it exporting your display using ssh or telnet to
your
Title: RE: Physical access to servers for maintenance
I meant install in general. It took forever to do it over a fairly weak network.
Never went in the computer room? Really?? Cool :) But did someone physically load the cd on the host for you? Or did you run it from your pc?
-Original
It's been a while but as I remember, for WinNT 4.0, I used to use the
windows network to log in to the server, put the CD-ROM in my workstation,
mount that on the server as a network drive, and do the GUI install. This
worked with 8.1.4.
You can restrict access to db by IP address.
JP
On Wed 26. September 2001 16:25, you wrote:
If I wish to do work on a database logging in to server itself and want to
prevent users from accessing the system via network is there another way to
do this if I don't want to use the enable
Title: RE: Preventing user access
Hi Sean,
someone on the list, his or her name escapes me, suggested two listeners. One for the general users and one for dba's only. You want to kick your users out, bring down the general use listener. Clever and slick!
Lisa Koivu
Oracle Database
You can use Connection Manager and define rules.
Although you will need to change the net services
entries of the tnsnames.ora or from the names or from
LDAP, just to source the client to the Connection
Manager before the server itself.
Or if you use TCP/IP as the protocol for Net8, you can
use
I presume you mean utl_file, not dbms_file. Doesn't this need the utl_file
parameter set up with the available directories - could you just check to
see if this parameter includes c:\log or /log
- Bill.
At 05:10 26/09/01 -0800, you wrote:
Hello
how is it possible in PLSQL to decide on
Yes...it's quite impressive looking
REAL metrics -- on top of sensible heuristics -- are hard to find.
-Original Message-
Sent: Tuesday, September 25, 2001 8:40 PM
To: Multiple recipients of list ORACLE-L
Analysis
Wow, I just went to read a few reviews on line and it does
Last time we tried an install from a remote CD it took about 4 times longer
to complete.
Ron
-Original Message-
Sent: Wednesday, September 26, 2001 9:55 AM
To: Multiple recipients of list ORACLE-L
It's been a while but as I remember, for WinNT 4.0, I used to use the
windows network to
Hi,
I think it's because they try to move more into the LDAP direction.
Stefan
JOE TESTA schrieb:
Don't forget this list is now to be used for oracle topics only. If
you want to post OT stuff, feel free to join the
[EMAIL PROTECTED] ist.
Although I've not seen the jokes/recipes on
1. What is the difference between a lock and a latch?
2. Explain what spinning is and why is it necessary?
3. What is the PL/SQL catch all exception called?
4. Where would you read about a deadlock that occurred?
5. How would you verify your data files you just backed up are not corrupt?
6.
me too -- Jared? please get rid of him?
--- Thomas, Kevin [EMAIL PROTECTED] wrote:
Does anyone else keep getting this message?
K.
---
[EMAIL PROTECTED] - no such user here.
Hi,
No such user found.Please check the Mail ID.
Regards
Sys Admin Team
: Message
You are right - DBMS_SUPPORT is for 7.something 8.0.5.
8i uses DBMS_SYSTEM AFAIK.
List, please correct me if I'm wrong..
Mark
-Original Message-
Trassens
Sent: Wednesday, September 26, 2001 13:55
To: Multiple recipients of list ORACLE-L
I think it comes with 8.0.4. I don't know
unable to open the zip files.
-Original Message-
From: Dharani Ravi [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: Performance problem with connect string (2nd attempt)
Hi,
Last week I had
I am getting it too. I thought it was only me...
Thomas, Kevin wrote:
Does anyone else keep getting this message?
K.
---
[EMAIL PROTECTED] - no such user here.
Hi,
No such user found.Please check the Mail ID.
Regards
Sys Admin Team
: Message contains [1] file
Title: RE: Physical access to servers for maintenance
We
keep images of the cd-roms for all current (and past) versions on a 'software
depot' (unix tar files)
so I
only need to have CDs loaded once for any given version. We only support
Oracle
on
Unix, no NT systems.
For
most versions I
If I was going to distribute a client VB application connecting to Oracle,
would I need to also distribute the Oracle Client tools or is there a small
driver package to install without all the tools?
Thanks,
Brian King
mailto:[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ:
Title: RE: Controlling disk space usage
Sean,
I assume from your question that you are already using autoextend on your tablespaces.
I personally do not use that option and therefore the chance of a tablespace expanding above available disk space never occurs.
However in the event of my
Hi,
When we do alter table table_name disable primary key cascade;..it also
disable all the foreign key constraints
but when we after do alter table table_name enable primary key..it does
not enable foreign keys
is there any syntax that we can enable all th foreign keys
I *did* miss you!
Obligatory Oracle Message:
Anyone hear about Oracle 10i yet?
-Original Message-
Sent: Tuesday, September 25, 2001 10:35 PM
To: Multiple recipients of list ORACLE-L
Analysis
Hehehe. I'll look at it. Just got back from vacation. I know you missed
me...
Scott
SATX
Title: RE: Physical access to servers for maintenance
Come
to think about it, access to my server room for Unix installs would be a
waste
of my
time. We have consoles on the servers with command line interface
only. Works
for
maintaince during downtimes when the network is out (planned
No guarantees as to accuracy, but I heard this story about 7 years ago from
someone who said he was there.
Apparently when the major Wall St. firms were deciding whether to go with
Oracle or Sybase they arranged to have both companies come in and do
presentations and say what special
We have one server which is generating 4+ MB daily on the dbsnmpc.log and
dbsnmpw.log. This is not generated on any of our other servers which are
all supposedly set up with the same standards. The alert logs look fine,
but the dbsnmpc.log, dbsnmpw.log, and nmiconf.log all show errors for
Title: RE: Preventing user access
-Original Message-
From: O'Neill, Sean [mailto:[EMAIL PROTECTED]]
If I wish to do work on a database logging in to server
itself and want to
prevent users from accessing the system via network is there
another way to
do this if I don't want
Can we block/filter whatever this message or user??
K.
-Original Message-
Sent: 26 September 2001 16:50
To: Multiple recipients of list ORACLE-L
I am getting it too. I thought it was only me...
Thomas, Kevin wrote:
Does anyone else keep getting this message?
K.
Title: RE: Platform
I've also used this query:
select substr (banner, 9, instr (banner, ':') - 9) as os
from v$version
where banner like 'TNS for %' ;
Because port_string is sometimes cryptic. For example, on my 7.3.4 database on Sun Solaris, here's what I get:
SQL select
Brian,
You need the SQL*Net/Net80 stuff to make the connection to Oracle.
Regrettably the only way I know to get that to work is to install the Oracle
Client. Otherwise there is bound to be something missing. OH, BTW: you'll also
need to tell the end user how to configure their ODBC
protocol.ora file is no longer supported in 9i.
joe
[EMAIL PROTECTED] 09/26/01 11:25AM
You can use Connection Manager and define rules.Although you
will need to change the net servicesentries of the tnsnames.ora or from the
names or fromLDAP, just to source the client to the
How are you connecting - if you are using odbc you will need the Oracle
client software.
-Original Message-
Sent: Wednesday, September 26, 2001 10:50 AM
To: Multiple recipients of list ORACLE-L
If I was going to distribute a client VB application connecting to Oracle,
would I need to
Hi DBA's
I have been visiting a client user site that is reporting frequent Dr.
Watson Application Errors when submitting report generation request from
Oracle Developer 6.0 forms on Oracle 8.0.5.0.0 client machines.
I observed that the same user can logon to another NT workstation and
This is what I eventually did and this fixed my database link problem.
I could have done it like another list member suggested to use the whole
edi.belkin.com in the database link name, but then I would have had to remember to do
this for any future database links, so the one time alter of the
That's why I said Net8. On 9i the new name is Oracle
Net and Oracle Net Services.
Regards.
--- JOE TESTA [EMAIL PROTECTED] wrote:
protocol.ora file is no longer supported in 9i.
joe
[EMAIL PROTECTED] 09/26/01 11:25AM
You can use Connection Manager and define rules.
Although you
VNC is fantastic, it's probably better for this sort of thing that a
combination of X11 and PC Anywhere.
Just for fun, I was running vncserver on a Sun, and vncclient on my
Win2K machine, then I started up vncserver on Win2K and fired up the
vncclient for Solaris (already running in a vncserver)
I will be using the book Oracle SQL*Loader The Definitive Guide to load
flat files into an Oracle 8.1.5 DB.
Would like to know if there are any errors / gotchas or missing information
in this book that I need to be aware of?
Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient Systems,
Hi
How to remove tablespace fragmentation?
Export/drop/import?
If I export the db and import user wise then is it solve the problem?
What are the precausion should taken care when we do such activities.
Thanks
-Seema
_
Get your FREE
He has been dispatched with alacrity, but not necessarily sanguinarily.
Jared
This electronic message contains information which may be confidential,
privileged or otherwise protected from disclosure. The information is
intended to be used solely by the named recipient(s). If you are not a
Title: RE: Physical access to servers for maintenance
You
can use a tool such as ControlIT to connect to NT machines. Its how I do
it, both from the office,
and
from home. How do all these people who claim you need access to the server
room to do the
day to
day stuff provide remote
Thanks to everyone that participated in this very informative, spirited and
amusing discussion of these products, I'm wondering if we should go with MS
server instead...
Miriam
-Original Message-
Sent: Wednesday, September 26, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L
No
I didn't say it was perfect. I just said that it worked. (grin)
If they insist on no physical contact then there are certain consequences,
including network traffic being hosed during installs. This is also how I
would install the client on users' workstations.
Hi,
When we do alter table table_name disable primary key cascade;..it also
disable all the foreign key constraints
but when we after do alter table table_name enable primary key..it does
not enable foreign keys
is there any syntax that we can enable all th foreign keys
it will be installable thru the net and only run on dos 10i, which can be
installed also.
joe
[EMAIL PROTECTED] 09/26/01 11:56AM
I *did* miss you!Obligatory Oracle
Message:Anyone hear about Oracle 10i yet?-Original
Message-Sent: Tuesday, September 25, 2001 10:35 PMTo: Multiple
interesting since the 9i docs basically say it wont be supported in the
future, but look how long it took for server manager and connect internal to go
away :)
joe
[EMAIL PROTECTED] 09/26/01 11:00AM
Joe,
I spoke to an
Oracle employee about this recently (in past month). Since we utilize
Title: RE: Physical access to servers for maintenance
Thanks Mark.
Lisa
-Original Message-
From: Mark Leith [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Physical access to servers for maintenance
Tony,
Kindof a neat package, but I'd be looking for something that does not need a
client to use it. I actually monitor my DB's from a program that then sends me
the exceptions to it's capabilities. Oh, well, back to the drawing board!!
Dick Goulet
Reply
--- O'Neill, Sean [EMAIL PROTECTED] wrote:
If I wish to do work on a database logging in to
server itself and want to
prevent users from accessing the system via network
Wednesday, September 26, 2001, 11:25:29 AM, Christian Trassens wrote:
CT You can use Connection Manager and define rules.
I use VNC a lot on Win32 platform, and it is unbearably slow. On Unix
platform it is much better.
Although I must say VNC uses almost no resources and it tunnel able through
SSH.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile
You want to make sure there is an index on the start with and connect by
clauses.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707)
Humm, IMHO Larry was right.
Reply Separator
Author: Miller; Jay [EMAIL PROTECTED]
Date: 9/26/2001 9:00 AM
No guarantees as to accuracy, but I heard this story about 7 years ago from
someone who said he was there.
Apparently when the major Wall St.
Title: RE: [Q] privilege allow user kill session???
From: Jacques Kilchoer
Write a procedure that kills the relevant session(s) and grant the user
execute access to that procedure.
-Original Message-
From: ef 8454 [mailto:[EMAIL PROTECTED]]
Thank you for the answer. Do you have
YTTRI Lisa would like to recall the message, ORACLE VS. SYBASE.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: YTTRI Lisa
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
You will need to distribute the drivers as well, of course, it depends on
the type of interface, ADO, DAO, OLE.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone:
Hi DBA's/Developers,
I've been monitoring our production Oracle database (8.0.5.0.0) on NT with
Spotlight on Oracle. I've also read some documents relating to Oracle
database tuning. I have identified some components that need to be tuned.
One of them is the SGA.
This is the current
Try restarting the agent process on this server. If you are using scheduled
jobs from OEM you will have to start these again. Remove the node from OEM.
On the server stop the agent. Remove all of the .q files from
ORACLE_HOME/network/agent. Then restart the agent and rediscover the node.
This
Title: RE: Physical access to servers for maintenance
Me
too. We've got our 4 Production Win2k servers (2 Oracle8i servers, 2
Webservers) at a colocation facility and have used either PCAnywhere or Terminal
Services to access them over the Internet for the last 9
months.
The
developers
Look them up. Its the best way to learn.
-Original Message-
Sent: Wednesday, September 26, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L
Hi Christopher,
So, are you going to tell the list what the answers are so that those
that don't know can benefit.
Martin
-Original
You can find the information here:
http://www.oreilly.com/catalog/orsqlloader/errata/
I have the same book, and think that it is a great one.
Brian
Ken Janusz wrote:
I will be using the book Oracle SQL*Loader The Definitive Guide to load
flat files into an Oracle 8.1.5 DB.
Would like to
Stick to delimited text files and you'll be fine.
Gary Weber
Senior DBA
Charles Jones, LLC||Superior Information Services, LLC
609-530-1144, ext 5529
-Original Message-
Miriam
Sent: Wednesday, September 26, 2001 1:26 PM
To: Multiple recipients of list ORACLE-L
Thanks to everyone that
We will be connecting OLEDB...
-Original Message-
B
Sent: Wednesday, September 26, 2001 12:55 PM
To: Multiple recipients of list ORACLE-L
How are you connecting - if you are using odbc you will need the Oracle
client software.
-Original Message-
Sent: Wednesday, September 26,
If you use Citrix on top of NT/2000 Terminal Services etc, your local
drives can be mapped.
I have used this to install printer drivers etc on a CD in my laptop onto
the server.
Local printers can be mapped too !
Steve Parker
Technical Consultant
LIS
--
1 - 100 of 152 matches
Mail list logo