most of the packages under SYS user are invalid
> when I compile it it's compile without error but when I back again the
> package still is invalid, anybody have any idea?
> Thanks in advance
>
> Hamid Alavi
>
> Office : 818-737-0526
> Cell phone : 818
idea?
Thanks in advance
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hamid Alavi
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Di
most of the packages under SYS user are invalid
when I compile it it's compile without error but when I back again the
package still is invalid, anybody have any idea?
Thanks in advance
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
--
Please see the official OR
-L
What is the value of your remote_login_password init parameter?
What is the value of SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora file?
-Original Message-----
Hamid Alavi
Sent: Monday, January 19, 2004 2:49 PM
To: Multiple recipients of list ORACLE-L
Hi list,
when I connect as sys/pa
in sqlnet.ora file?
-Original Message-
Hamid Alavi
Sent: Monday, January 19, 2004 2:49 PM
To: Multiple recipients of list ORACLE-L
Hi list,
when I connect as sys/password as sysdba I get an error not sufficient
privilege but I can connect internal, How can I set my SYS user to connect
All,
I have an strange problem, most of the packages under SYS user are invalid
when I compile it it's compile without error but when I back again the
package still is invalid, anybody have any idea?
Thanks in advance
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416
recipients of list ORACLE-L
Hi list,
when I connect as sys/password as sysdba I get an error not sufficient
privilege but I can connect internal, How can I set my SYS user to connect
as sysdba.
I am running on 8.1.7.4 Windows 2000 Professional edition.
Thanks,
Hamid Alavi
Office : 818
Hi list,
when I connect as sys/password as sysdba I get an error not sufficient
privilege but I can connect internal, How can I set my SYS user to connect
as sysdba.
I am running on 8.1.7.4 Windows 2000 Professional edition.
Thanks,
Hamid Alavi
Office : 818-737-0526
Cell phone
Dear List,
I want to upgrade from 8.1.5 to 8.1.7 on windows 2000 what's the safest way
to do this upgrade.
If any body knows any url or have any kind of document it would be very
helpful.
Thanks & happy new year to all of you.
Hamid Alavi
Office : 818-737-0526
Cell phone :
SSION 00056
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hamid Alavi
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, Calif
where sysdate between
effective date & end date).
Any Idea?
Thanks,
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hamid Alavi
INET: [EMAIL PROTECTED]
Fat City Network Servic
eate a rule or some thing like this which any select statement
select the data from these lookup where the sysdate between effective date &
end date.
Example:
select * from table1 ( always select those records where sysdate between
effective date & end date).
Any Idea?
Thanks
ct those records where sysdate between
effective date & end date).
Any Idea?
Thanks,
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hamid Alavi
INET: [EMAIL PROTECTED]
Fat City Network Servic
List,
Is any body know when Oracle stop supporting for 8i?
Thanks,
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hamid Alavi
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858
List,
How can I user comma " ' " in my update statement?
update tablea set fielda =' james'ste Camp 'first,'sec' '
Thanks,
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
--
Please see the official ORACLE-L FAQ:
List,
any body know any module or reference to get the next business day including
holidays etc.
Thanks,
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hamid Alavi
INET: [EMAIL PROTECTED
nder oracle
8 to oracle 9 database & it's working fine from 8 to 9, but when I try to
use this link from 9 to 8 it's failed to ORA-12154.
Any idea what could be this??
Thanks allot for your help.
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
--
Pleas
2154.
Any idea what could be this??
Thanks allot for your help.
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hamid Alavi
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858
List of guru,
Is any body know how can I create a text file from store procedure without
using utl_file , I want to create & write a text file from result of a
select statement and write the result as a text file in a define directory.
Thanks for your help.
Hamid Alavi
Office :
Hi List,
Today I have dropped a big tablespace(4 Gig) as soon as I dropped it the
data file also disappeared from the list of datafiles, as I know the
datafile must be removed manually Any idea?
I am using 9.0.1 on solaris 2.8
Thanks,
Hamid Alavi
Office : 818-737-0526
Cell phone
ison, any URL or help
would be appreciate
Thanks in advance.
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hamid Alavi
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-
; (partition part2 VALUES LESS THAN (TO_DATE(' 2004-12-30 00:00:00'))
>
> can the indexes be like this:
>
> create index idx_1 on test(col2)
> tablespace users
> OR
>
> I have to create all the indexes as partition index?
>
> Appreciate your help
>
> Thanks,
&g
our help
Thanks,
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hamid Alavi
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
160 M, My
question is do I have to calculate the size of tables for the life cycle of
database(for example 5 years) or Some thing else?
Example: tableA size = 10M in first year so this table must be multiple
5 and assume as Medium size or NOT?
Thanks,
Hamid Alavi
Office : 818-737
then decide if
this table is in the range of small table or NOT.
Any Idea appreciate.
Thanks,
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
=== Confidentiality Statement ===
The information contained in this message an
Title: RE: LMT monitoring
I had
the same problem,You have to generate the script with dbassist then run the
script.
-Original Message-From: Milen Pankov
[mailto:[EMAIL PROTECTED]Sent: Tuesday, March 11, 2003 9:00
AMTo: Multiple recipients of list ORACLE-LSubject: can't
crea
pinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion
is an art!
-Original Message- From: Hamid
Alavi [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 31, 2003 2:43 PM To: Multiple recipients of
al Message-
Sent: Friday, January 31, 2003 11:09 AM
To: [EMAIL PROTECTED]
Cc: Hamid Alavi
Hamid,
Here is one way:
SQL> select myseq.currval from dual;
CURRVAL
--
4
SQL> alter sequence myseq nocache;
Sequence altered.
SQL> alter sequence myseq maxvalue 4 cycle
sequence number reinitiate and start from 1 again.
Thanks for your help.
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
=== Confidentiality Statement ===
The information contained in this message and any attachments is
inten
Kirti,
I test it it doesn't work.
-Original Message-
Sent: Friday, January 31, 2003 11:09 AM
To: [EMAIL PROTECTED]
Cc: Hamid Alavi
Hamid,
Here is one way:
SQL> select myseq.currval from dual;
CURRVAL
--
4
SQL> alter sequence myseq nocache;
Seque
Dear List,
How can I reinitiate a sequence Instead or dropping & recreating it, I want
every night my sequence number reinitiate and start from 1 again.
Thanks for your help.
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
=== Confidentia
5 AND
c.evh_task_list_id = 469602))
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
=== Confidentiality Statement ===
The information contained in this message and any attachments is
intended only for the use of the individual or ent
DEAR LIST,
How can I import from a dump file which has some partionioned table into
another user with no partitioning.
Thanks in Advance
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
=== Confidentiality Statement ===
The
Dear List,
I just wondered how come still every body talking about some off topic like
orawomen!!! and nobody even interseted to answer my question regarding
insert/updatble view?
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
List,
Oracle8i support insert/updatable view or NOT?
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
=== Confidentiality Statement ===
The information contained in this message and any attachments is
intended only for the
ize = 134217728
sort_area_retained_size = 262144
sort_area_size = 262144
timed_statistics = TRUE
I realy appreciate your help and assistant. I am getting confused, just
want
to know changing any of these parameter help the performance to reduce
the
number of CONSISTANT G
Hi Again,
Another question is, if i increase the following parameter is there any
negative effective or not?
1) db_block_buffers = 1change to 2
2) hash_area_size = 2048000 change to 5120 5 M
3) log_buffer = 262144change to 5242880 5 M
Thanks
Hamid Alavi
g any of these parameter help the performance to reduce the
number of CONSISTANT GETS or NOT???
Thanks in advance.
Hamid Alavi
Office 818 737-0526
Cell818 416-5095
=== Confidentiality Statement ===
The information contained in this message a
ame effect
in both cases.
Jared
On Wednesday 13 November 2002 09:54, Hamid Alavi wrote:
> Dennis,
>
> Here it is in the oracle performance tuning (Tip's & Techniques) page
735
> suggested value for LOG_CHECKPOINT_INTERVAL = 999.
>
> My oracle version is 8.1.7.4
ical Idea.
Thanks for your help.
Hamid Alavi
Office 818 737-0526
Cell818 416-5095
=== Confidentiality Statement ===
The information contained in this message and any attachments is
intended only for the use of the individual or entity to wh
statistics = TRUE
Hamid Alavi
Office 818 737-0526
Cell818 416-5095
=== Confidentiality Statement ===
The information contained in this message and any attachments is
intended only for the use of the individual or entity to which it is
addresse
?
THanks for HELP>
Hamid Alavi
Office 818 737-0526
Cell818 416-5095
=== Confidentiality Statement ===
The information contained in this message and any attachments is
intended only for the use of the individual or entity to which it is
addres
mation. Please contact the sender immediately by return
e-mail and delete the original message from your system.
= End Confidentiality Statement =
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
INET: [EMAIL PROTE
i have just part of table loaded .
Thanks for your help.
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement ===
The information contained in this message and any attachments is
intended only for the use of the
Hi List,
Is there any way that I can check to see if the value in a variable is a
number?
Example:
is_number('100') = TRUE
is_number('ABC') = FALSE
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement
partitioned can we
export it without partitioning info, so I could import it in my default
tablespace, second question is how can I continue to import this sort of
table completely.
Now i have just part of table loaded .
Thanks for your help.
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
US7ASCII NCHAR character set
import server uses US7ASCII character set (possible charset conversion)
IMP-00069: Could not convert to environment national character set's handle
Is there any solution.
Thanks.
Hamid Alavi
Office 818 737-0526
Cell818 402
other one get error , do I have to change some configuration??or
add another instance to the list of instance, if YES how and where do I have
to do that?
Thanks allot
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement
ter.
In my configuration it has been set to 1 as default and I have two CPU so it
means it should be 6*2 = 12?is it right?
Thanks allot for your recommendation.
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement ==
is message in error, you are prohibited from copying, distributing, or
using the information. Please contact the sender immediately by return
e-mail and delete the original message from your system.
========= End Confidentiality Statement =
--
Please see
to_number(a.MSC_SERVICE_CODE) between 7 and 30
Any Idea ? why this hapenning?
Thanks Allot.
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement ===
The information contained in this message and any atta
version of a
varchar2 in number.
LYNDA HAOUHACH
Ingénieur Systèmes
SONATRACH LTH
Émail: [EMAIL PROTECTED]
> -Message d'origine-
> De: Hamid Alavi [SMTP:[EMAIL PROTECTED]]
> Date: lundi 24 juin 2002 11:23
> À:Multiple recipients of list ORACLE-L
> Objet:
7;8','7','6','5','4','3','2','1','0')) a
where
to_number(a.MSC_SERVICE_CODE) between 7 and 30
Any Idea ? why this hapenning?
Thanks Allot.
Hamid Al
onnected.
Is anybody had some simillar problem, any Idea?
Appreciate for Help.
Thanks,
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement ===
The information contained in this message and any attachments is
in
1501: CREATE DATABASE failed
ORA-01990: error opening password file
'/opt/app/oracle/product/8.1.7/dbs/orapw'
Disconnected.
Is anybody had some simillar problem, any Idea?
Appreciate for Help.
Thanks,
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== C
e simillar problem, any Idea?
Appreciate for Help.
Thanks,
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement ===
The information contained in this message and any attachments is
intended only for the use of the ind
List,
Is it possible to Unistall Patch4 from 8.1.7.4 on sun solaris, We have an
application running on 8.1.7.0 but when we upgrade to 8.1.7.4 the
application can not retreive data from a table with long column format.
I realy appreciate if any clue?
Hamid Alavi
Office 818 737-0526
Cell818
colc from tableA where cola=1 and colb='A'
>
> cola colb colc
> 1 Axx
> 1 A
> 1 Ammm
>
> Any Idea? what's wrong and what's cause a problem?
> I appreciate any recommendation.
>
>
>
rom tableA
then
select cola,colb,colc from tableA where cola=1 and colb='A'
cola colb colc
1 Axx
1 A
1 Ammm
Any Idea? what's wrong and what's cause a problem?
I appreciate any recommendation.
Hamid Alavi
Office 818
Hi List,
I have few tables with a lot of transaction by many users, I change the
Initrans from 1 to 5 and for some to 25, My question is what's the best way
to findout which value is the optimum value for INITRANS for each table?
Thanks for Help.
Hamid Alavi
Office 818 737-0526
Cell
?
Thanks,
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement ===
The information contained in this message and any attachments is
intended only for the use of the individual or entity to which it is
addressed, and may
the same.
> Any Idea?
> And what about normal index & reverse index? when we have to use normal
and
> when reverse index, I think Reverse index normaly using for FK index, Is
it
> right or not?
> Thanks
>
>
>
>
>
> Hamid Alavi
> Office 818 737-0526
> Ce
Thanks ALL, Specialy Igore.
-Original Message-
Sent: Friday, June 07, 2002 3:28 PM
To: Multiple recipients of list ORACLE-L
Read The Frigging Manual
> -Original Message-
> From: Hamid Alavi [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 07, 2002 5:28 PM
>
onstrint & unique index, when we
have
> to
> > use which, I think both are the same.
> > Any Idea?
> > And what about normal index & reverse index? when we have to use normal
> and
> > when reverse index, I think Reverse index
l message from your system.
= End Confidentiality Statement =
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
use normal
and
> when reverse index, I think Reverse index normaly using for FK index, Is
it
> right or not?
> Thanks
>
>
>
>
>
> Hamid Alavi
> Office 818 737-0526
> Cell818 402-1987
>
>
>
>
>
>
> === Confidentiality St
nformation. Please contact the sender immediately by return
e-mail and delete the original message from your system.
= End Confidentiality Statement =
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
INET: [EMAIL PROTE
s it
right or not?
Thanks
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement ===
The information contained in this message and any attachments is
intended only for the use of the individual or entity to which it is
a
I am running two listener on one server, How can I stop logging for specific
listener, Itry to do this but dosn't work:
set log_status listener2 off, also I have tried with set log_status
listener2 0, but non of them are working.
Any Idea?
Hamid Alavi
Office 818 737-0526
Cell818 402
Reply Separator
Author: Hamid Alavi <[EMAIL PROTECTED]>
Date: 6/4/2002 12:02 PM
Hi
I have sent the following message to list this morning, but unfortunaitly
havn't received any response for that, don't know is any body recived it or
not?
Your respond to this one is
Hi
I have sent the following message to list this morning, but unfortunaitly
havn't received any response for that, don't know is any body recived it or
not?
Your respond to this one is very valuable for me
thanks
> -Original Message-
> From: Hamid Alavi
>
/oracle
runinstaller under /u04/app/oracle/bin just a link to runinstaller on
/u01/app/oui/install
Can I just copy runinstaller 8.1.7 to /u01/app/oui/install directory and use
the link or not?
Thanks for your Help
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
ts.
In most cases both the oratab and orainventory files are found under
/var/opt/oracle.
Hamid Alavi wrote:
>
> List,
>
> Can some body tell me what's the usage of oratab & orainst.loc files (sun
> solaris OS), I am getteing confused because I have two diffrent
Oracle_hom
the system (8i and above).
A single oratab file is used by all versions of Oracle to set
ORACLE_HOME and ORACLE_SID in the dbshut/dbstart scripts.
In most cases both the oratab and orainventory files are found under
/var/opt/oracle.
Hamid Alavi wrote:
>
> List,
>
> Can some b
from the patch set oracle 8i patch
set 8.1.7.4.0" and doesn't go thru at all, My question is for installing
any patch do I have to install the previous patch first or what?
Is there any Prepatch to Install for any patching or NOT?
We have two option for upgrading 8.1.7.2 OR 8.
do I have to install the previous patch first or what?
Is there any Prepatch to Install for any patching or NOT?
We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better &
safer??
If I want to go for Patch 4,is there any comments or recommendation
Really appreciate
Hamid Alavi
Of
&
safer??
If I want to go for Patch 4,is there any comments or recommendation
Really appreciate
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement ===
The information contained in this message and any attachments is
in
hing or NOT?
We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better &
safer??
If I want to go for Patch 4,is there any comments or recommendation
Really appreciate
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement
.1.7.4, Which one is better &
safer??
If I want to go for Patch 4,is there any comments or recommendation
Really appreciate
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement ===
The information contained in this
installing
any patch do I have to install the previous patch first or what?
Is there any Prepatch to Install for any patching or NOT?
We have two option for upgrading 8.1.7.2 OR 8.1.7.4, Which one is better &
safer??
If I want to go for Patch 4,is there any comments or recommendation
Really apprec
Hi List,
I have decided to Upgrade the database from 8.1.7.0 to 8.1.7.4 this
afternoon on sun solaris.
Please give me any advise before I go for upgrade.
Thanks allot and have a good weekend
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality
Thanks for respond, Now I want to know which Patch of Oracle 8.1.7 is 64 bit
for solaris 64 ?
Thanks again
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement ===
The information contained in this message and any
Hi List,
Which command I have to run to findout Installed oracle running under 32 bit
or 64 bit???
Oracle 8.1.7.0 or 8.1.6.2 my OS sun solaris, running under 64 bit now
Thanks
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement
hen I rebuild the table with
same data running OK.
Oracle 8.1.7.0 & 8.1.6 sun solaris
Thanks in Advance
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement ===
The information contained in this message and any at
24405
DBMS_UTILITY24212
DBMS_SPACE_ADMIN20832
DBMS_UTILITY20508
DBMS_JAVA 15189
DBMS_OUTPUT 13063
DBMS_APPLICATION_INFO 12461
DBMS_SHARED_POOL11148
DBMS_SHARED_POOL
y return
e-mail and delete the original message from your system.
= End Confidentiality Statement =
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858
Hello List,
I got the following error today(Oracle 8.1.7.0 Sun Solaris)
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared
pool","unknown object","sga heap","state objects")
At the moment my shared_pool size is 30M
Thanks for your help
HI,
IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE
DATABASE(8.1.6.2 ON SUN SOLARIS)
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement ===
The information contained in this message and any
it up, I
run
ALTER TABLESPACE TEMP COALESCE BUT STILL DATA FILE IS FULL
ORACLE 8.1.7.0 ON SUN SOLARIS
\THANKS ALLOT
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement ===
The information contained in t
using the information. Please contact the sender immediately by return
e-mail and delete the original message from your system.
= End Confidentiality Statement =
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
IN
Hi Experts,
I have download patch2 for 8.1.7 for Sun Solaris, just want to check with
you is there any specific things I have to do for this upgrade or not.
How much space(on oracle home) need for this upgrade?
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
x27;t know why you are getting the ORA-3113
> >
> > I was merely trying to offer some advice based on limited information.
> >
> > ORA-3113 is a 'catch all' error; any number of things can cause that
> > error.
> >
> > Are there other errors a
s can cause that
> error.
>
> Are there other errors associated with it?
>
> Please include the list in your replies so as not to limit responses to
> one individual.
>
> And the advice to move to 8.1.7.2 still holds.
>
> Jared
>
>
>
>
>
> Hamid Alavi <
y, May 02, 2002 1:48 PM
> I don't know why you are getting the ORA-3113
>
> I was merely trying to offer some advice based on limited information.
>
> ORA-3113 is a 'catch all' error; any number of things can cause that
> error.
>
> Are there other error
Where can I download the Patch2 for Oracle 8.1.7.0 SunOS 5.7
I couldn't find anything like Patch2 or Patch3
Thanks for HELP
-Original Message-
Sent: Thursday, May 02, 2002 11:22 AM
To: [EMAIL PROTECTED]
Cc: Hamid Alavi
Which version exactly?
If on version 8.1.7.0, you should up
CREATE DATABASE "CMSREPT"
*
ORA-03114: not connected to ORACLE
Disconnected.
Thanks
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement ===
The information contained in this message and any attachments is
full path and name of the INIT.ORA file
Review the ORADIM log file for any errors.
Hamid Alavi
ovadx.com> cc:
Sent by: Subject: Create New Instance
[EM
T.ORA' ->> BUT HERE IN INIT FILE WE
HAVE TO MENTINED THE CONTROL FILE THIS SHOULD BE JUST THE LOCATION & NAME ??
SO WHEN I RUN THIS SCRIPT THE DATABASE & INSTANCE WILL BE CREATED OR I HAVE
TO DO MORE STEPS.
THANKS FOR HELP
Hamid Alavi
Office 818 737-0
HI AGAIN,
JUST WANT TO CHECK WITH YOU GUYS, MY LISTENER.LOG IS GETTING BIG I TRY TO
RENAME IT THEN CREATE A NEW LISTENER.LOG BUT STILL THE OLD ONE IS USING BY
ORACLE.
HOW CAN I TRUNCATE THE LISTENER.LOG OR CAN I JUST SIMPLY DELETE IT OR NOT?
THANKS FOR HELP.
Hamid Alavi
Office 818 737-0526
;tableb COL1 BLOB
ACTUALY I DON'T WANT TO STORE BLOB,CLOB IN SAME TABLE JUST NEED THE REFRENCE
TO THE CLOB,BLOB OBJECT.
THANKS ALL
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
=== Confidentiality Statement ===
The information c
1 - 100 of 182 matches
Mail list logo