MOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other info
mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subs
, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing
List,
I'm interested to
know the minimum required parameters to startup the
database.
Pls anybody list out
that?
Nirmal.,
Title: AW: How to create two db-links within one schema when global_names=tr
Hi,
Where
these two, V$SYSTEM_PARAMETER, V$PARAMETER dynamic view are
differs?
Both
of them looks the same in structure and data as
well.
Anybody have any idea.
Nirmal.
-Original Message-From:
Title: SQL puzzle - using where (a, b, c) in select (a, b, c from...) and columns can be null
SQL> edWrote file
afiedt.buf
1 select * from
widgets_copy 2* order by 1,2,3SQL> /
ID COST
SELL-- --
--
1
10
20
select
record_identifier from records where rownum<(
select 40-count(*)
from
(select 1 from
customer_view
union all
select 2 from unit_view)
);
Just a thought,
HTH.
Nirmal.
-Original Message-From: Savita
[mailto:[EMAIL PROTECTED]]Sent: Monday, November 11, 2002 11:13
AM
er the two columns of data from the datafile
'c:\temp\file2.csv'
should go into one column(remark) of my table.
Oracle7.3.1. Any ideas pls.
Thanks.
Nirmal.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
INET: [EMAIL PROTECTED]
or other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and
line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
INET: [EMAIL PROTEC
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORAC
ou may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
Hi
syed...
srw.run_report ('d:\test.rdf destype=file
desname=try.out desformat=dflt batch=yes');
The
above will work fine. You should not mention 'report' keyword in the command
line. This is the
mistake in reports help.
Nirmal.
Prior
Deveoper, Current OCP DBA.
-Original Mes
t;
> Nirmal.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nirmal Kumar Muthu Kumaran
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
>
Hi gurus...
I friend newly bought a laptop with windows XP. He wants to install oracle
8i on it.
Is it possible to install oracle 8i in XP?. Is there any patch i need apply.
Thanks.
Nirmal.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
AQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
---
tax gives invalid col name :
exp test/test file=expt.dmp tables=x1
query=\"where x1_cd in \(\'207\'\)\"
EXP-8: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-0: Export terminated unsuccessfully
--
Please see the official ORACLE-L FAQ: http://www.oraf
ubscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mai
: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORAC
Title: RE: Covert tnsnames.ora to OID
OID?..
-Original Message-
From: Yechiel Adar [SMTP:[EMAIL PROTECTED]]
Sent: Mon, May 27, 2002 06:58 PM
To: Multiple recipients of list ORACLE-L
Subject: Covert tnsnames.ora to OID
Hello All
How can I covert all the name
Title: RE: "snapshot too old" error - strange
Increase rollback segment size for this transaction and make sure that the
transaction will use the huge rollback segment
hth
nirmal
-Original Message-
From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]]
Sent: Mon, May 27, 2002 15:53
To
Title: Help me on ORacle Character Set
Hi...all
I have installed oracle9i in my desktop winNT with arabic language support. While creating database i chosen US7ASCII.
Even then all error messages are showing in arabic, and i couldnot able to read it.
Can anyone suggest me a needful to sol
Title: RE: Errors on Alert file
ORA-00602
ORA-00602internal programming exception
Cause:An internal programming exception has occurred.
Action:Report this error as a program bug to Worldwide Customer Support.
nirmal.
-Original Message-
From: GL2Z/ INF DBA BENLATRECHE [SMTP:
Title: RE: MTS and Dedicated Server
Hi...
1) Just comment or remove the init.ora parameters related with mts.
2) Configure the database as MTS. By default all connections uses dispatchers.
If you want to made a dedicated connection, configure ur tnsnames.ora accordingly.
Means add the at
Title: jre error while installing ora817
Guru's
I faced the following problem while installing oracle 8.1.7 on winNT pack4.
"Not all the dependencies for the component Oracle Enterprise Manager Common Files 2.2.0.0.0 are found.
Missing Component oracle.swd.jre 1.1.8.10.0"
Before i was i
Title: RE: Please ignore: Internet DBA'ng
How?
-Original Message-
From: Sujatha Madan [SMTP:[EMAIL PROTECTED]]
Sent: 04 ÕÝÑ, 1423 09:08 AM
To: Multiple recipients of list ORACLE-L
Subject: Please ignore: Internet DBA'ng
Solved this issue.
> -Original Message--
Title: RE: Table Insert Lock!!
Hi subra( my ex-pm name),
Hope that ur not pricise in ur ?.
If suppose to keep at maxinum of 1 record at time( like dual), you can restrict this, by
table level trigger of INSERTING.
Sorry if i was u/s wrongly.
Nirmal.
-Original Message-
From:
Title: RE: system packages status is invalid Oracle 8.1.7 on red hat 7.2
May be running the script file resolve the problem, but i could not find that why the packages
became invalid after the application creation.
any idea anyone ahve?
Nirmal.
-Original Message-
From: Boivin,
Hei all,
Hope that there are totally 504 init.ora parameters in ORacle8i. Out of that
only 203 parameters
only documents, remaining are undocumented. This i read on a white
paper. Where should i get information about these parameters? Just i
want to know.
Here is my Q.
the init.ora paramet
Hi all,
init.ora
--
db_block_size = 2048
db_block_buffers = 10240
db_block_lru_latches=3
buffer_pool_keep=(buffer:1024, lru_latches:1)
buffer_pool_recycle=(buffer:512, lru_latches:1)
After instance startup,
SYS@SECDB> select name, value from v$parameter where name like
'buffer_pool%'
N
; Hi Nirmal ,
>
> While importing u have to consider that the source and target databases
> character sets should be matching U can change the character set of your
> target database using props$ data dictionary view
>
> HTH
>
> Gholam
>
> > -Orig
Hi guru's,
Can someone guide me how to do the migration from oracle7.3.1 to 8.1.7.
I have all full cold backup of Oracle731 database.
Now i want to migrate it to Oracle817.
What i did is:
1) i created a new service using oradim command,
2) Modified init.ora file accordingly and restored all
Helo gurus,
I exported on schema from the old datatabase and then
i created new database in my PC. Now i want to import it,
but it's saying that characterset is not match error.
How can i rectify it
Thanks.
Nirmal.
<>
Title: Data Archiving
Hi all,
New year Greetings.
We need to archive some history tables from the production database to new server. Totally around 50 history
tables we need to move and each table having around 10 million of records. Some of history tables having records, which are require
Title: RE: RE: Change PCTINCREAE for SYSTEM Tablespace
Hi Tom,
Can you review my views in changing pctincrease value:
If i'm creating database manualy without dbassistant,
The steps are,
1) CONNECT INTERNAL
2) CREATE DATABASE ( LOGFILES, A SINGLE DATAFILE FOR SYSTEM TABLESPACE AND other i
Title: RE: Trigger
Hi
if (col1,col2,col3) are forming primary key means, then how come you
insert value for any one of primary key columns, if so it would not give error for NOTNULL
nIRMAL,
-Original Message-
From: Mercadante, Thomas F [SMTP:[EMAIL PROTECTED]]
Sent:
Title: RE: which view for hidden objects
what u mean by hidden tables?... views? or synonyms?
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Sent: 28 ÑãÖÇä, 1422 12:11 AM
To: Multiple recipients of list ORACLE-L
Subject: which view for hidden objects
W
Title: Tuning FAQ's
Hi gurus,
I wish to know very familiar questions or usual questions related with
Oracle Tuning and backup and recovery.
Hope that everyone will input their ?'s.
Rgds,
nirmal.,
Title: RE: Message at the start of svrmgrl
What are the new things on oracle 8.1.7.2.1 patch.
is't available on oracle downloads...?
I'm much interested to know "why should apply this patch" is it for to rectify some bugs or something else...
Rgds,
Nirmal
-Original Mess
Title: RE: how to pass argument to a dos batch program from sqlplus
Have you been tried for it?
It'll work fine.
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 5:25 AM
To: Multiple recipients of list ORACLE-L
Subjec
Title: RE: simple sql problem
Hi...
You cann't run sql statement in command line directly However you can in case of script file.
Make the query as a script file. Then run it on SQLPLUS.
-- c:\test.sql
-
select * from emp
/
exit
/
: Determinants of control file
Hi Nirmal,
Use
alter database backup controlfile to trace;
You can find these details in the trace file, that will be dumped to your udump destination.
HTH
Srinivas.
-Original Message-
From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL
Title: RE: GRANT REFERENCES
Oracle itself saying that, you cann't create foreign key for a remote database table.
To achive this, use database triggers.
Let me know if am wrong?
Nirmal.
-Original Message-
From: Ekan Emokpae [SMTP:[EMAIL PROTECTED]]
Sent: Thursday,
Title: RE: enable the partitioning option in database?.
i didn't find the directory ORACLE_HOME\rdbms\lib itself... there is one directory jlib, but in that there is no 'make' file
my system is ora817 on win nt.
any help pls.
-Original Message-
From: Molina, Gerardo [SMTP:[E
Title: Enable the partitioning option in database?.
-Original Message-
From: Nirmal Kumar Muthu Kumaran
Sent: Wednesday, November 28, 2001 4:56 PM
To: '[EMAIL PROTECTED]'
Subject: enable the partitioning option in database?.
hI GURUS'
How c
Title: Determinants of control file
Hi all,
The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc.,
But after creation of control files, where should i get details about these parameter values?...
i checked in v$controlfile and v$database... i didn't g
Title: enable the partitioning option in database?.
hI GURUS'
How can i enable the partitioning option in database?.
Any idea?
[EMAIL PROTECTED]> SELECT PARAMETER, VALUE FROM V$OPTION WHERE VALUE='FALSE';
PARAMETER
VALUE
Title: RE: Analyze only latest partition
Hi
Why not you can try with partition related dictionary views:
Here is my query:
[EMAIL PROTECTED]> select table_name, partition_name, high_value,
partition_position from dba_tab_partitions a where partition_position =
(select max(partition_
Title: RE: Unable to run catalog.sql
the catalog.sql Must be run when connected to SYS or INTERNAL.
Is it true for ur case?
Nirmal.,
-Original Message-
From: Ken Janusz [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 10:00 PM
To: Multiple recipients of list ORACLE
Title: RE: OEM for Personal Edition cannot connect
guys,
please give more details about this management server in oracle.
i tried many times to connect on it... the same error i got vtk-1000..etc.
never i succeeded on it
thanks.
Nirmal.
-Original Message-
From: Sinard
Title: RE: HELP : doubts regarding --- Tablespace ,Roll Segment , diff between oracle 8i and 9i, and between oracle 8i and previous versions - urgent
Hi sangeetha,
Well, hope that u want to know all in big things in one struch ;-).
Ok, here are my answers to you.
1) If the tablespace
Title: RE: create trigger and create any trigger
hI
You must have "create any trigger" privilege to create trigger on any table which in other schema.
The "alter any table" will allow you to change the structure of table, but not to create trigger on it.
-Original Message-
Fr
MTP:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 10:21 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle 9.0.1.1.1 on Win2k: stalls during installation: 85% "D
Dan,
It sounds like the 817 install left some trash around.
If I were you, [Nirmal Kumar Muthu
Title: RE: Find DBA users
[EMAIL PROTECTED]> select grantee from dba_role_privs where granted_role='DBA';
GRANTEE
--
SCOTT
SYS
SYSTEM
[EMAIL PROTECTED]> grant dba to nirmal;
Grant succeeded.
[EMAIL PROTECTED]> select grantee from dba_role_privs where granted
Title: Grant a cluster?
Hi.. guru's...
Sorry if it's a basic question
Can i grant a grant a cluster to any user?
Oracle document says, the object may be a table/view/sequence/synonym/procedure/package/funtion/...etc., except cluster.
It means, we cann't grant a clusters?
Title: RE: aps_data_files
i didn't find any view as like 'APS%' in db dictionary...
Is any one have found a view like this?
-Original Message-
From: Tatireddy, Shrinivas (MED, Keane) [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, November 22, 2001 2:30 PM
To: Multiple recipients
as posted a question without giving enough info. Folks need to be clearer with they are asking for.
Without this kind of info . you will probably never get a response.
-Original Message-
From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November
Title: RE: close_cached_open_cursors "error"
Hi...
how i can come to know about all x$ tables...
is there dictionary is there for it?
Please let me know.
Rgds,
Nirmal.
-Original Message-
From: Christian Trassens [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, November 22, 2001 6
Title: RE: SQL question
update set id = substr(id,-4);
eg:
[EMAIL PROTECTED]> select substr('48900322',-4) from dual;
SUBS
0322
1 row selected.
Nirmal.
-Original Message-
From: Malik, Fawzia [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 7:04 PM
To:
Title: parallize printing reports to different printers
Hi all,
A report producing multiple 1000 (say 5000) pages producing and we want to print it. However we don't want the
user to be idle until it completes. So we plan to reduce the printing time by distributing (say 1000 each) report pag
Title: selftest q's doubt
Helo guru's
I had small doubts, may be it's trival too.
Please remind me, How the following statements are true:
a) "Imiplicit cursors process only one row at a time"
Eg. Suppose a delete statement wipe off 10 rows from a table.
This case How many rows are pro
Title: RE: List of synonyms
[EMAIL PROTECTED]> COLUMN OBJECT_NAME FORMAT A30
[EMAIL PROTECTED]> SELECT owner, object_name, object_type FROM dba_objects WHERE object_type='SYNONYM';
OWNER OBJECT_NAME OBJECT_TYPE
-- -
Title: RE: utl_file example
Hi,
Verify "UTL_FILE_DIR" init.ora parameter is defined properly.
In FOPEN function specify, filepath and filename as separate.
[EMAIL PROTECTED]> ;
1 DECLARE
2 fid UTL_FILE.FILE_TYPE;
3 BEGIN
4 fid := UTL_FILE.FOPEN('c:\','test.log','w');
Title: RE: How can I tell if a procedure/package is running?
Hi adams
What should i get details of X$ tables.
How much these tables are important as a DBA..
Rgds,
Nirmal,
-Original Message-
From: Steve Adams [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001
Title: RE: Moving the ALert and Dump Locations
yES, BY USING INIT.ORA PARAMETER BACKGROUND_DUMP_DEST
nIRMAL.
-Original Message-
From: Denham Eva [SMTP:[EMAIL PROTECTED]]
Sent: Monday, October 29, 2001 12:15 PM
To: Multiple recipients of list ORACLE-L
Subject: Moving
Title: RE: Rebuilding Indexes Question
I think, rebuilding indexes may use the existing index to build, so that the performancce will improve comparitively doind drop and create indexes...
Nirmal.,
-Original Message-
From: Alex Hillman [SMTP:[EMAIL PROTECTED]]
Sent: Sunday, Octo
Title: Oracle9i-Download
Hi guru's
anybody had an exp of downloading oracle 9i for nt/2000 from oracle site?
I downloaded 3 winzip files. But i'm not able open the 2nd zip file,
i got winzip error" Cannot openfile: it does not appear tobe a valid archive" however 1st and 3rd are p
Title: RE: Move table to another tablespace
hi...
can you give the exact steps for ur 2nd option.
1)exp scott/tiger tables=emp,
2)alter user scott default tablespace tools,(before it's users)
3)imp scott/tiger fromuser=scott touser=scott
But still oracle imports to users tablespace itse
Title: RE: Move table to another tablespace
in your 3rd option, you must create all constraints(except notnull) for the new table, if any. + ur checklists.
Nirmal.
-Original Message-
From: Hallas John [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 2:35 PM
To: Mul
Title: RE: Oracle 9i CD
http://download-east.oracle.com/otndoc/oracle9i/901_doc/nav/docindex.htm
Here is all, Oracle9i Database List of Books
(Release 9.0.1; includes Windows books)
Rgds,
Nirmal.
-Original Message-
From: Sinard Xing [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, Oc
Title: RE: Why does ittake long time?
Have you checked, whether the query will be using the indexes, if u have any...
Nirmal,
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 2:26 PM
To: Multiple recipients of list ORACLE-
Title: RE: sequence pool
Can you provide a small brief about the scenario, where exactly you want the bulk of sequences.
Just want to know, until now i didn't face this scenario in my dev.
Thanks,
Nirmal,
-Original Message-
From: Doug C [SMTP:[EMAIL PROTECTED]]
Sent: Thursday
Title: RE: Droping System User
hi
I took risk in my test DB by dropping the user 'SYSTEM'. As you tested, the same steps i repeated in mine, all are fine, until before.
Now i shutdown my database and startup again, here the problem arises. Oracle mount the database but while opening t
Title: sys.obj$, type# desc
hI gurus'
[EMAIL PROTECTED]>;
1* select obj#, name, type# from sys.obj$ where name like 'DBA%' and rownum < 4
[EMAIL PROTECTED]> /
OBJ# NAME TYPE#
- -- -
1149 DBA_ROLES
Title: RE: Export - Import from Oracle v8 to v731
Hi christopher,
How i can make my orace8 server compatible with v731... is i can set any init.ora parameter
or something different
Nirma,
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Wedn
Title: Export - Import from Oracle v8 to v731
Hi gurus,
i need to transfer db design of a small application from oracle v8(winnt) to v731(vms=vax).
I successfully completed the export process:
c:\>exp80 parfile=c:\exp_par.dat
exp_par.dat
---
userid=msalah/msalah@qtel
fi
Title: RE: MAIL on insertion/updation of a record.
I'm redirecting you to
http://asktom.oracle.com/pls/ask/f?p=4950:8:162284::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:319216860351,%7Bsend%7D%20and%20%7Bmail%7D
This link explains how to send email through developer2000 forms. Hope that using
Title: RE: privileges on packages
USER_TAB_PRIVS.
Here is an example:
[EMAIL PROTECTED]> create or replace package my_pack is
2 type abc_t is table of number index by binary_integer;
3 p_abc abc_t;
4 p_un varchar2(20);
5 end my_pack;
6 /
Package created.
[EMAIL PROTE
RACLE-L
Subject: Re: For update - Where current of
On Saturday 29 September 2001 07:50, Nirmal Kumar Muthu Kumaran wrote:
> Hi gurus
>
> Can any one give the usage of 'for update' clause, while declaring a
> cursor in Pl/sql?
>
>
'Where current of'
ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mail
___
> Do You Yahoo!?
> Get email alerts & NEW webcam video instant messaging with Yahoo!
> Messenger. http://im.yahoo.com << File: Listener.zip >>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu
--
> Organon (Ireland) Ltd.
> E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode]
>
> Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
>
> "Nobody loves me but my mother... and she could be jivin' too." - BB King
>
> >> From: Nirmal Kumar
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command
TED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the officia
List,
In multiple database instances, how can i find the background processes of
appropriate instances?..
reGARDS,
nIRMAL.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
Hi guru's
Suppose that, i'm managing serveral database from a single client.
In that case, how can i find out the alert log/trace files from the client.
Any ideas pls.
Regards,
Nirmal.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Mut
moved from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
om
> --
> Author: Mercadante, Thomas F
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> --------
>
> I am hoping someone knows the equivalent of inspdver in 8i and above. Can
> you please let me know.
>
> thanks
>
> Anjan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
INET: [EMAIL PROTECTED]
Fat City Networ
d two services to run those
> listeners.
>
> You'll probably need to read the manuals for the exact details.
>
>
>
>
>
> Nirmal Kumar
>
> Muthu KumaranTo: Multiple recipients of
> list ORACLE-L
>
user?
>
> Regards
> Nirmal.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nirmal Kumar Muthu Kumaran
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California
> How to find the current instance name for the session?.
>
> From svrmgrl, i can using "SELECT name FROM v$database".
>
> What is the equivalant from the ordinary user?
>
> Regards
> Nirmal.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.c
name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
INET: [EMAIL PROTECTED]
Fat City Network Services
also send the HELP command for other information
> > (like subscribing).
>
>
> ______
> Terrorist Attacks on U.S. - How can you help?
> Donate cash, emergency relief information
> http://dailynews.yaho
List,
How to find the current instance name for the session?.
>From svrmgrl, i can using "SELECT name FROM v$database".
What is the equivalant from the ordinary user?
Regards
Nirmal.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu K
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be
ances on the same server?.
>
>
> Presently am able to create only one instance at a time either for the sid
> 'orclsvr' or 'ora817'.
>
> Oracle Server 817 on Win NT4 based.
>
> Regards,
> Nirmal.
> --
> Please see the official ORACLE-L FAQ: http:
ey are residing on
> the same machine, in different oracle homes? ... One database is version
> 8.0.6 and the other is 8.1.7.
>
> Thanks
>
> Sujatha
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
INET: [EMAIL PROTECTE
-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a li
#x27; or 'ora817'.
Oracle Server 817 on Win NT4 based.
Regards,
Nirmal.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Cal
1 - 100 of 140 matches
Mail list logo
