Kevin,
You need Oracle Enterprise to use the
partition feature.
For a comparison of features between EE and
SE please see http://otn.oracle.com/products/oracle8i/pdf/8i_fam.pdf
Yuval.
-Original Message-From: Kevin Lange
[mailto:[EMAIL PROTECTED]]Sent: Monday, August 20, 200
Title: Oracle Learning Network
Hi,
Has any of you taken advantage of the $99 offer from Oracle Learning Network??
For those who use it, can you give your opinions of its content and quality.
Thanks.
Yuval.
Title: ORA-1410
Hi,
I am running the following command
analyze table BLOB compute statistics
and I am getting the following error.
*
ERROR at line 1:
ORA-01410: invalid ROWID
Metal link tell me to export,drop,import the table.
Does anyone know of a way to fix the table without dropp
Title: ORA-12701 on Oracle 9i
Dear dba list,
I have a test 9.0.1 database that was working fine. After being down for while (no time to play with it) I tried to start in and I am getting the following errors.
Metalink does not help.
Machine is Sun 420 OS 5.7,
SQL> conn sys/manager as sysdb
Title: 9i install.
Hi,
I am trying to run dbca (the new name for dbassist) on Sun Solaris 2.7 and I get the following
java.lang.NoClassDefFoundError: org/omg/CORBA/UserException
at oracle.sysman.emSDK.common.registry.PropertiesFileRegistry.get(Proper
tiesFileRegistry.java:44)
ion...as i recall it should be
1.1.7 or better for 9i.
-Original Message-From: Yuval Arnon
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 11, 2001
2:20 PMTo: Multiple recipients of list
ORACLE-LSubject: 9i install.
Hi, I am
trying to run dbca (the ne
Check
the definition for COMPROBANTES_RECORD and
the SELECT statement.
You
have one extra column AGENCIA in the record which is not in the
SELECT..
Yuval.
-Original Message-From: Ramon Estevez
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 19,
2001 2:13 PMTo: Mul
Title: Oracle standby strange behavior
Hi,
I ran into a strange behavior of a standby database.
On the primary db I have an application schema and a query schema.
All tables from the appl schema have public synonyms and a grant select to public.
User query is created with connect and resource
the original DB.
Before you activate standby,
do
1. On
production
SQL> alter system
switch logfile;
2. Transfer all archived logs
to standby and make sure they are applied.
Hopefully, no more
problem.
Vadim
-Original Message
Original Message-----From: Yuval Arnon
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 30, 2002
1:41 PMTo: Multiple recipients of list
ORACLE-LSubject: Oracle standby strange
behavior
Hi, I ran into a strange behavior of
a standby database. On the primary db I
Title: Dropping users from Oracle 9i seed database.
Hi,
Using Oracle Configuration Manager a handful of users are created. Which of these users can be safely dropped without affecting Oracle health.
List of users.
AURORA$JIS$UTILITY$
CTXSYS
HR
LB
This
is from Oracle Metal Link.
The CF
locks are used to serialize controlfile transactions and read and writes on
shared portions of the controlfile. For example, these locks would be
used for - switching logfiles, held exclusive. - updating checkpoint
information for datafiles, held exc
Title: Unix shell Question
Hi,
Need help in Unix shell.
Is there a way to compute the previous date (similar to sysdate - 1 in SQL) using the date expression??
So if my date is 3/1/2002 I will get 2/28/20002.
TIA
Yuval.
Title: Database Metrics
Hi,
I am looking for ideas on what kind of metrics the DBA group should provide the management on a weekly basis so they can understand how the databases are evolving over time.
These metrics should be simple enough as the management is not Oracle savvy.
Thanks in
Title: RE: Oracle 8i database & ER diagram
Has
anyone successfully installed Oracle 9i on Sun Sparc (available from
technet).
Trying
to gzip -d the files I get 'file is not in gz format'
Yuval
Arnon.
Title: FW: finding "grant exec"
Look at dba_tab_privs. Contrary to the column name in dba_tab_privs the table_name column shows all procedures and packages.
For example:
SYSTEM> grant execute on dbms_pipe to scott;
Grant succeeded.
SYSTEM> select * from dba_tab_privs where grantee = 'SC
Title: RE: Oracle support phone number
1-407-240-8900
-Original Message-
From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 4:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Oracle support phone number
Could somebody give me support 800 or long dist
Title: RE: CASE Expressions
Jonathan
CASE is not supported in 8.1.7.
SQL> select * from v$version;
BANNER
Oracle8i Enterprise Edition Release 8.1.7.1.0 - Produ
Title: RE: Dedicated / Multi Threaded oracle server.
check this link
http://www.elementkjournals.com/dbm/9802/dbm9821.htm
Yuval.
-Original Message-
From: Kumar, Dharminder [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L
Subj
*
ERROR at line 4:
ORA-06550: line 4, column 6:
PLS-00382: expression is of wrong type
ORA-06550: line 4, column 1:
PL/SQL: Statement ignored
Yuval Arnon
Title: Max number of sessions
Hi,
I would like to find out how to compute/estimate the maximum number of sessions a db can handle.
Preferably based on the init.ora params sessions and processes, size of sga, size of ram, the /etc/system params etc.
This is for a db running using MTS.
TIA
21 matches
Mail list logo