RE: All packages under sys is invalid

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

RE: All packages under sys is invalid

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

RE: All packages under sys is invalid

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

RE: SYS Privilege

-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

RE: SYS Privilege

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 pakages under sys is invalid

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

RE: SYS Privilege

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

SYS Privilege

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

Upgrade

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 :

Export Error

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

RE: Create Rule

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

RE: Create Rule

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

Create Rule

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

8i Support

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

Using ' in Update statement

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:

NEXT BUSINESS DAY

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

RE: Antw: Database Link

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

Database Link

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

Text file from store procedure

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 :

Drop Tablespace

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

Compare Schema with data

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-

RE: index partition

; (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

index partition

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

Table Size?

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

TABLE SIZE

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

RE: can't create database

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

RE: Reinitiate Sequence Number

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

RE: ReInitiate Sequence Number

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

RE: ReInitiate Sequence Number

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

RE: ReInitiate Sequence Number

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

ReInitiate Sequence Number

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

SQL Tuning

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

IMPORT QUESTION

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

STRANGE

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

View Question?

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

RE: CONSISTANT GETS

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

ini file

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

CONSISTANT GETS

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

RE: Check Point Interval Question

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

Check Point Interval Question

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

CPU Problem

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

Partition Question

? 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

RE: Temp problem

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

RE: IMP/EXP Problem

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

Function

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

IMP/EXP Problem

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

Import Error

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

Using Statspack

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

db_block_lru_latches

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 ==

RE: NEED YOUR OPINION

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

RE: NEED YOUR OPINION

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

RE: NEED YOUR OPINION

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:

NEED YOUR OPINION

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

RE: Database Creation Problem

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

RE: Database Creation Problem

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

Database Creation Problem

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

Uninstall Patch

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

RE: Strange Bug

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. > > >

Strange Bug

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

INITRANS question

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

Locking Issue

? 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

RE: Index & Constraint

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

RE: Index & Constraint

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 >

RE: Index & Constraint

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

RE: Correct way to determine freelists and freelists groups

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

RE: Index & Constraint

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

RE: Index & Constraint

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

Index & Constraint

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

Two Listener

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

RE: FW: UPGRADE PROBLEM

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

FW: UPGRADE PROBLEM

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 >

UPGRADE PROBLEM

/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

RE: Upgrade Question

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

RE: Upgrade Question

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

RE: Upgrade Question

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.

RE: Upgrade Question

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

RE: Upgrade Question

& 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

RE: Upgrade Question

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

RE: Upgrade Question

.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

Upgrade Question

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

UPGRADE

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

64 BIT ORACLE FOR SOLARIS 64 BIT

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

QUESTION 32 BIT or 64 BIT

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

NEED YOUR ADVISE

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

RE: Shared Pool Tuneup

24405 DBMS_UTILITY24212 DBMS_SPACE_ADMIN20832 DBMS_UTILITY20508 DBMS_JAVA 15189 DBMS_OUTPUT 13063 DBMS_APPLICATION_INFO 12461 DBMS_SHARED_POOL11148 DBMS_SHARED_POOL

Shared Pool Tuneup

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

ANY IDEA?

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

SHARED POOL SIZE

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

TEMP TABLESPACE

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

RE: Upgrade is Necessary?

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

Upgrade from 8.1.7 to 8.1.7.2

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

RE: Create a new database

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

RE: Create a new database

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 <

RE: Create a new database

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

RE: Create a new database

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 a new database

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

RE: Create New Instance

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

Create New Instance

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

SIMPLE QUESTION

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

STORE BLOB,CLOB

;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   2   >