Where can you get this firebird browser?
Reginald W. Bailey
IBM Global Services
JPMC Account - DCI ETS Database Management
Your Friendly Neighborhood DBA
[EMAIL PROTECTED]
[EMAIL
Do you mean Windows 2003 Advanced Server? Check the compatibility matrix
on Metalink.
RWB
Reginald W. Bailey
IBM Global Services
JPMC Account - DCI ETS Database Management
Your
Sure. You can try the Change Management Pack for Oracle Enterprise Manager
from Oracle. Then there is the bevy of tools from Quest software.
DB Artisan is another.
RWB
Reginald W
account is within the grace period or locked.
RWB
Reginald W. Bailey
IBM Global Services
JPMC Account - DCI ETS Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281
If it is a matter of encryption, turn on encryption by adding the
encryption login parameter to the sqlnet.ora file.
RWB
Reginald W. Bailey
IBM Global Services
JPMC Account - DCI ETS Database
server, then they will each have different port numbers.
Then change the entries in the tns names files or name server to accomodate
the change.
RWB
Reginald W. Bailey
IBM Global Services
Jared:
You can't find it in Oracle8i? Probably because Oracle8i does not have
dbms_support. I believe it was introduced in Oracle 9i Release 1.
RWB
====
Reginald W. Bailey
IBM G
ad" sites.
RWB
========
Reginald W. Bailey
IBM Global Services
JPMC Account - DCI ETS Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile)
[EMAIL PROTECT
The service for OracleTNSListener will show up once the Listener is
started. Try starting it from the command line using lsnrctl. This has
worked for me.
RWB
Reginald W. Bailey
IBM
userid.
Or drop the stored program and reimport it after hours. This would also
compile it.
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly
, you
could run it the way you have configured it.
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798
you budget 1 GB per Oracle instance.
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile
IF it is not too much trouble, could you e-mail me a copy of the article
Mogens?
Thank you.
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[EMAIL
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[EMAIL PROTECTED
RWB
====
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[
What? 9.2.0.4 is out now?
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713
Have you considered using a function based index?
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281
Free? Vat is dis Free? All of us don't work for Oracle (at least not
directly) so we don't get that perk. But thanks for sharing.
RWB
Reginald W. Bailey
IBM Global Service
Rahul:
It sounds like your implementation is very similar, in theory, to Oracle's
Fine Grain Access. Are you re-inventing the wheel?
====
Reginald W. Bailey
IBM Global Services - E
RWB
====
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[
Sandro:
We are having problems creating the objects and granting the
access. We figured out that our problem is granting the access because we
were intended to use the DBA's login, but we can't because the only one
that can grant access to the object is the owner, correct?
Yes. Have th
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[EMAIL PROTECTED
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[EMAIL PROTECTED
using the AT batch commands, then no local administrator rights are needed.
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713
Try using the SQLPlus command COPY or the SQL command create table xxyy AS
SELECT * FROM dddrrr. Or use OEM or some other GUI tool.
RWB
Reginald W. Bailey
IBM Global Services - ETS SW
ve
me, you do not want this to happen. So, as long as you use the resident
installer, 9i, then you should not have a problem installing the 8i
software.
RWB
====
Reginald W. Bailey
IBM G
or report is running.
========
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECT
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[EMAIL PROTECTED
les change. This offers a faster
execution of the query.
So , wheneve possible use NDS for faster execution (most of the time) and
less work in the processing part (reparsing, etc.).
RWB
or a customer's
vapor backup plan that worked the first time.
========
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (
a
couple of ways to avoid this.
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile
ole to the users, and at run time use the package
procedure
DBMS_SESSION.SET_ROLE.
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood D
.
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[EMAIL
Joan:
Where did you get the FORFILE.EXE program from? And, yes I will look at the
NT script.
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly
elps.
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[EMAIL
etc.
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
[EMAIL PROTECTED]
[EMAIL
I prefer to create an inner block using BEGIN and END inside the loop. This
isolates the DML statements. The COMMIT is issued inside the BEGIN and END
block.
RWB
Reginald W. Bailey
IBM
"sqlplus / as sysdba".
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5
No. There wasn't one in Oracle8i 8.1.7 either. If you're using Solaris 7 or
8, you're all right.
RWB
========
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database
Just install the Oracle client. You can probably download it from
technet.oracle.com if you don't have a CD.
RWB
====
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Dat
You mean the size parameter was changed in 2000, not to the value 2000?
Try increasing the LARGE_POOL_SIZE to at least 2MB or more, preferably 8MB
or more.
RWB
Reginald W. Bailey
IBM
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager
Yes it is.
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager
specification or body
declaring the P_IC variable.
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798
What attachment?
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager
Mr Shakir:
Can you tell me the URL for the "Tim Gorman website, and Steve Adams
website"?
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
You
==
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415
.
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database Management
Your Friendly Neighborhood DBA
713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager
.
Reginald W. Bailey
Your Friendly Neighborhood DBA
Try using PL/SQL tracing , available in Oracle8i and Oracle9i.
DBMS_TRACE.SET_PLSQL_TRACE (trace_level INTEGER).
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database
Also in the dbshut, change the connect internal to use sqlplus and "/ as
sysdba" as the connectivity string. This is the approved method for
Oracle8i and Oracle9i.
Reginald
The Oracle Names utility namesctl or namesctl.exe on WinNT starts the Names
Service. It can also be started from the Services page of the control
panel. The names.ora file contains the configuration information as well
as sqlnet.ora. The Net8 Configuration Assistant can be used to configure
the N
Majid:
1) Try "select name from v$database;"
2) Use the "connect" keyword to connect to another database. Example :
connect userid@database_name.
3) To create users, try
"create user [username] identified by [password] default
tablespace [tablespace_name]
temporary tablespace
Dennis:
I have had some experience with developers using ADO. First, are they
using ODBC or OLE for the database connectivity between ADO and the
database.
If they are using ODBC, determine if it is Microsoft 's or Oracle's ODBC.
The version of Microsoft's ODBC the developers were using did not
Use the translate command "tr". Type "man tr" for help with using it.
RWB
"Guang Mei" <[EMAIL PROTECTED]>@fatcity.com on 02/03/2003 12:39:48 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Hi:
I h
Glenn:
You already know the questions and seem to be pointed to the answers. We
put multiple schemas in an instance when there is a similarity. If the
schemas belong to the same
business unit or department, and they are similar applications, like OLTP,
then we can put them in the same instance.
Yes. We have SQL Server and two versions of Oracle installed on the same NT
server. No ill effects have been observed. They do not interfere with
each other when installed correctly.
RWB
"Mercadante, Thomas F" <[EMAIL PROTECTED]>@fatcity.com on 01/21/2003
07:19:01 AM
Please respond to [EMA
I believe the lock was obtained on the table prior to updating the rows.
So a commit would signal an end to the work and release any objects that
were locked.
Either that or the session has some kind of separation or withdrawal
problem.:)
RWB
--
Please see the official ORACLE-L FAQ: http://www
We faced a similar problem. We use change control to help manage this.
The developers have the schema password in development , but not in UAT
(Certification) or Production. We create a run-time userid for their
application to use rather than logging in as the schema owner. The
run-time userid
Bob:
Try running the scripts in the command line version of SQL Plus. In NT use
sqlplus instead of sqlplusw. The statscusr.sql prompts for a couple of
tablespaces.
Start spooling right after logging in and set termout and echo on. You
should capture some output this way.
RWB
"Bob Metelsky
Seema:
Use an index, obviously. If and index exists, ensure that the query uses
it. The select columns order should match the order of the index columns.
Or try using a HINT.
Sometimes a full scan is not a bad thing. Are there less than 100,000 rows
in the table? Sometimes the optimizer will
What is the URL for this product?
RWB
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Valerie:
What is the audit parameter in the init.ora file set to? Is it set to
database (db) or os files? What are the other audit parameters in the
init.ora file set to?
RWB
Webber Valerie H <[EMAIL PROTECTED]>@fatcity.com on 01/02/2003
01:45:17 PM
Please respond to [EMAIL PROTECTED]
S
Donate:
Does the owner of the procedure have system privilege granted directly to
them to create a view? Not with a role , but with the system privilege
granted directly to the procedure owner. Remember, roles are disabled
inside a stored procedure.
RWB
"Donate Clothes" <[EMAIL PROTECTED]>
To issue OS commands from PL/SQL for NT, there is no other option. Now if
your PL/SQL was an anonymous block then you could issue OS commands via SQL
Plus.
Otherwise , you will have to use C or Java.
RWB
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL
I don't get it. "Do a minus"? Mr. Shao could you explain that please.
RWB
"Shao, Chunning" <[EMAIL PROTECTED]>@fatcity.com on 11/22/2002 02:49:15 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
The f
The releases should be tried in the Development environment first. Then a
UAT (User Acceptance Test) environment, then production. The UAT
environment is usually a duplicate of the production environment. This is
the environment that you implement the changes , then test to see if the
changes wo
Bob:
Let's try the simple solution first. How about using the Services utility
in Control Panel to check the service for startup ="AUTO". Then specify
the parameters that are
to be used for startup, like "pfile=xx". Specify the userid that is
supposed to start the database, preferably not
Suggestion 1: Try having the trigger call a procedure. Put the update
code from the trigger in a procedure.
Suggestion 2:The mutating table error is a row-level trigger. The
solution is to use a statement level trigger and a row level trigger.
Use a PL/SQL table inside package to record t
You need to set the credentials for the node. If you are doing an export
on the node, OEM must be able to log into the node. As good practice, you
should create a valid userid and password for each node listed by OEM. OEM
cannot run a job on a node without having a userid to log onto the node
w
My bad. Instead of OUI use DBCA.
RWB
Reginald W. Bailey/JPMCHASE@[EMAIL PROTECTED] on 10/31/2002 03:54:29 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
I must disagree. There is no $ORACL
I must disagree. There is no $ORACLE_HOME/admin//scripts. There is no
admin directory under $ORACLE_HOME. In 9.2.0 you must create a template
first by using the default configuration, save it, then exit the OUI. Then
start it up again and use the existing template. Go through the normal
prompts a
The BLOB can be "in line" if the size is less than 4k, otherwise it is
stored as "out-of-line".
RWB
"Gene Sais" <[EMAIL PROTECTED]>@fatcity.com on 10/29/2002 07:39:01
AM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL P
I beg to differ Mr. Holman. The sqlplus command should work if the "/ as
sysdba" is enclosed in quotes. So , the command would be
sqlplus "/ as sysdba" . This works in Oracle9i on Unix and Windows NT/2000
environmnents. At least it does so in my environments.
RWB
Rodd Holman <[EMAIL PROTE
Raj:
The date column has a timestamp value as well. By using the TRUNC
function, you are getting all dates regardless of the time value (i.e.
12:01 AM, etc.) . When dealing with DATE datatypes it is always a good
practice to use the TRUNC function on the columns to prevent the time of
day portio
Here is an example that I created years ago using the Korn shell.
load_status=0
SQLSCRIPT=createLoadRecord.sql
LOGFILE="${TEMPDIR}/createLoadRecord${ID}.log"
SQLPLUS=${ORACLE_HOME}/bin/sqlplus
print "The Source CRS is ${SOURCECRS} \n"
SQLSTMT="set serveroutput on;
Santosh:
If the installation was to a PC, then check what type of installation was
installed. If you used the Enterprise Edition Server CD then you should
have chosen the "Custom" installation or "Client/DBA" installation option.
The "Client/End User" option does not install Import and Export u
James and list:
You can backup the database without stopping the services. Just shut it
down. If you are going to attempt a restore and blow away the control
files, etc., then
by all means stop the services first. The services would need the control
files to be present if it is to be restarted
Yes, I do. This ploy worked on some of the large corporations in the U.S.
And I happen to know this worked on at least one large financial
institution.
RWB
DENNIS WILLIAMS <[EMAIL PROTECTED]>@fatcity.com on 10/21/2002
01:48:54 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROT
to discover the node.
Reginald W. Bailey
DBA, Consultant and MOKF
John Weatherman <[EMAIL PROTECTED]>@fatcity.com on
10/17/2002 03:10:41 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
An
restart the agent
after making the change.
Then try to discover the node.
Reginald W. Bailey
DBA, Consultant and MOKF
John Weatherman <[EMAIL PROTECTED]>@fatcity.com on
10/17/2002 03:10:41 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipie
Private rollback segments usually are listed in the init.ora file. Public
rollback segments are created with the "PUBLIC" parameter and are available
to multiple instances that accesses the same database. Private rollback
segments are also explicitly acquired when an instance opens a database.
Okay, I will concede the point. Sometimes having multiple listeners can be
a good thing. Although running older versions of the listener may not be.
But you pay your money and you take your chances. Thank you for those who
cited published sources. Please remember: what an Oracle analyst will
You can use compress or gzip to compress a file. compress -v [filename]
should compress the file and tell you the percentage as well. Gzip is a GNU
utility that may be on your system. These utilities may not be in your
current path.
RWB
WLSH <[EMAIL PROTECTED]>@fatcity.com on 10/16/2002 0
It is better to have a single Listener per server, unless you have multiple
servers that use high availability fail over between the servers. The
single listener should be the most recent one on the server. It is
backwards compatible with Oracle8i versions and Oracle7 databases. There
is no n
You can use the default userid that OEM creates for repository ownership
(SYSMAN) and call it a day. OR Look at the privileges that SYSMAN has and
compare it
to the userid you created. I would suspect that some system privileges
would have to be granted directly to the userid instead of via a ro
No. Try using DBMS_IJOB.REMOVE. It is an undocumented package that can be
used by SYS or a DBA to remove other user's jobs. It is one of the DBAs
secret tools
and should not be shared with lesser mortals. If this code is violated, we
will find you! :)
RWB
Ray Stell <[EMAIL PROTECTED]>@f
I have used Change Management Pack. It helps manage changes when you need
to capture them , especially when moving from Development, to
Certification/UAT and Production. It can reverse engineer existing
databases and schemas, but it does not put the files in a usable format.
The files are in a
Greg:
If the error is coming from DBMS_OUTPUT, then it is probably PL/SQL
related. Try increasing the LARGE_POOL_SIZE parameter in the init.ora
file. I would suggest setting it to at least 2MB. By the way, what are the
shared_pool_size and large_pool_size parameters set to now?
RWB
"Greg
Try setting the GLOBAL_NAMES parameter in the init.ora file to FALSE for
the target database.
RWB
"Ben" <[EMAIL PROTECTED]>@fatcity.com on 09/20/2002 01:21:34 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTE
You can spool Oracle output into text files using SQL*Plus. Excel can
handle plain text and Comma Delimitted Text files.
RWB
Bob Robert <[EMAIL PROTECTED]>@fatcity.com on 09/20/2002 03:33:24 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of
Paula et al:
It could work if the analyze is done after the load using DBMS_STATS. Then
the num_rows would be accurate. With the monitoring turned on , analyzing
would be done on the
table if more than a certain percentage had changed. It is not an elegant
solution. A more pratical one , if y
Try this:
select table_name, num_rows from dba_tables where table_name
= [table_name];
[table_name] = the name of the table or a variable.
This works if you are updating your statistics and you may also want
monitoring turned on for the table.
It is easier to get the information from the data d
Thomas:
Try setting the LD_LIBRARY_PATH environment variable. Typically for
Solaris it is set to the following:
export
LD_LIBRARY_PATH=/lib:/usr/lib:/usr/ccs/lib:/usr/dt/lib:/usr/ucblib:$ORACLE_HOME/lib:$ORACLE_HOME/network/lib
export LIBPATH=$LD_LIBRARY_PATH
If you still get that error, try
It's called SQL Plus. Set the heading off, pagesize = 0, linesize = 200,
set record delimiter = ',' or '|' and set feedback off; and termout on.
This should produce an ASCII file once you supply your own query.
RWB
ltiu <[EMAIL PROTECTED]>@fatcity.com on 09/05/2002 01:05:07 PM
Please resp
Mr. Estevez:
The service names are defined in the init.ora using the service_names
parameter. You can have several names separated by commas and white space
to represent service names. The Listener can listen for a specific service
name if you list it in the listener.ora file. Oracle8, 8i an
When configuring two versions of ORacle on a single machine , whether it is
NT or UNIX, always use the Listener of the most recent version. It is
backwards compatible.
RWB
Denham Eva <[EMAIL PROTECTED]>@fatcity.com on 08/30/2002 03:28:19 AM
Please respond to [EMAIL PROTECTED]
Sent by:
I've been an Oracle DBA and developer for many years (more than 10) and I
have also been a Unix Sys Admin (about 5 years). I am used to playing god
with the server , where I am the DBA and the System Administrator. (Of
course these days, a lot of companies and clients want a segregated
environmen
1 - 100 of 105 matches
Mail list logo