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
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
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
if
the 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
into it.
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 Management
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
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 PROTECTED]
[EMAIL PROTECTED
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 Global
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
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
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
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
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 Services - ETS SW
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 - ETS SW
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
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
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
and not
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
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
, 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 Global
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
. There are 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
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 (Office) 281-798-5474
. 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
Reginald W
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 DBA
713-216
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
.
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
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
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
/ 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-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
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
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 - Database
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 Management
Your
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
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
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
.
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
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
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 W. Bailey
IBM
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
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
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 have a
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 [EMAIL
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
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:
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
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
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
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
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
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]
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:
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
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 the
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
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
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
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
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
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
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
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;
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
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
and 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 recipients of list
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:
Anybody seen anything like this? I am
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.
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
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
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
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
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
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
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 PROTECTED]
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
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
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
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
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
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
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
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:
Bruce:
Actually I have seen this. My server installations were at 8.1.7.3 and I
applied the 8.1.7.4 patch to it. The version still says it is 8.1.7.3 and
the package STANDARD is invalid.
This was on AIX 4.3.3. On the Solaris installations, I have not had a
problem. Check out my TAR on
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
Start the Installer and check on previously installed Oracle products. If
the Oracle Inventory file is bad or does not show any installed 8.1.7
product, then you will have to re-install the 8.1.7 version over the
existing one, then you can install the patches (8.1.7.4 is the latest).
Start the
Does the row have a column with a DATE or timestamp datatype? If so, is
there a trigger or DEFAULT value associated with the insert action? Was
Audit turned on? If auditing was on for the table and for inserts or
updates, then you should be able to determine which record was entered
last.
RWB
Usually I try to create the view using a CREATE or REPLACE VIEW option.
This saves me the trouble of dropping the view. If the view is invalid,
right after trying to create the view , issue the command show errors.
(You can get the view definition from the log file.) This will usually
give
1 - 100 of 101 matches
Mail list logo
