Rajesh,
On the SQL*Plus prompt type the follwoing
define _editor = vi
Note the underscore before editor. This will make the editor vi for the
SQL*Plus session. To make it permanent, put the line in
$ORACLE_HOME/sqlplus/admin/glogin.sql, so that it will be executed evey time
the SQL*Plus sessions
Ave !
Set environment variable EDITOR=vi
Br.Jorma
-Original Message-
Sent: 13 September, 2003 10:09
To: Multiple recipients of list ORACLE-L
Dear Friends,
ed command in SQLPLUS( on UNIX ports )not working. I hope there is some
EDITOR setting to use VI editor, but forgot where to do th
Hi Rajuveera,
Put these two lines in your .profile
EDITOR=vi
export EDITOR
HTH,
Rajesh
Rajesh Dayal
Senior Oracle DBA (OCP 8,8i,9i)
International Information Technology Company LLC
-Original Message-
Sent: Saturday, September 13, 2003 11:09 AM
To: Multiple recipients of list
Dear Friends,
ed command in SQLPLUS( on UNIX ports )not working. I hope there is some
EDITOR setting to use VI editor, but forgot where to do that. Can somebody
give a thought.
Thanks
Rajuveera
**
This email (including any a
The following URL will take you to the CHAR vs. VARCHAR semantics
section in the PL/SQL developers guide.
As Tim says, use varchar2 if possible. If not possible, you should
closely study the following
http://tinyurl.com/mvfj
Jared
On Wed, 2003-09-10 at 03:29, Fermin Bernaus wrote:
>
>
Faan,
the Doc. below has the reference of 52576.1.
--> "Note:1069019.6 Subject: HOW TO GET A CLEAN RMAN CATALOG"
so, i was looking for that too.
i read the doc. 1058332.6 already.
You are the only one who responded to my question.
Thanx Faan.
Jp.
13-9-2003 04:49:27, Faan DeSwardt <[EMAIL PRO
Well, we've begun to put good stuff about RAID-F on www.BAARF.com,
including the good writing by Art Kagel mentioned below.
One of the fantastic gems that just arrived today from a good source is
the one from Sun where they describe a very unique way of implementing
RAID-10 that actually makes
As I've said earlier, take a look at the server. Look in the alert.log.
On 2003.09.12 19:09, bhabani s pradhan wrote:
yes that problem is resolved
actually there are two problems:
1] Solaris Error: 12: Not enough space
sys admin killed some processes and now other client machines can
connect and wo
Upgrading RAC 9203 to 9204 on Solaris.
First step is to upgrade ORCLudlm to 3.3.4.6. We ran
into issues when running package if Install group is
other than dba (it hardcodes the group as dba in one
of the files it uses). We had to manually edit the
file to get it to work.
Had to upgrade to fix a
yes that problem is resolved
actually there are two problems:
1] Solaris Error: 12: Not enough space
sys admin killed some processes and now other client machines can
connect and work on the db
2]tnsping and sqlplus on one particular client machine give
Bus Error (core dumped)
seems its a disk c
Then, you have a problem with the number of processes on the OS level. The
investigation should continue on the server.
--
Mladen Gogala
Oracle DBA
> -Original Message-
> From: bhabani s pradhan [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 12, 2003 5:46 PM
> To: Mladen Gogala
>
listener is running okay
it has refused some connections:
WW_DB> lsnrctl stat
LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 12-SEP-2003
14:49:01
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of th
While running tnsping and sqlplus i am getting this:
WW_WS> tnsping TRADEDB1
Bus Error (core dumped)
WW_WS> sqlplus rubix/[EMAIL PROTECTED]
Bus Error (core dumped)
WW_WS> /usr/sbin/ping 10.10.8.44
10.10.8.44 is alive
WW_WS> echo $ORACLE_HOME
/export/home/oracle/product/8.1.7
WW_WS> echo $ORACLE_SI
On the 9.2.0.3 databases I checked, it is 3.
> -Original Message-
>
> Can't get my hands oon 9.2.0.2 or 0.3, but in 0.4 (on Windows), the
> _kghsidx_count defaults to 1 anyway, check it out on your systems.
>
> Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
A
You cannot start process. You need to increase PROCESSES in
init$ORACLE_SID.ora.
You may have to increase SHMMAX and SEMMNS in /etc/system.
--
Mladen Gogala
Oracle DBA
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of bhabani s pradhan
> Sent: Fr
Oddly enough, I received the same error today on one of our Solaris
servers while trying to start a listener. I ran 'top' and noticed that all
of the available swap space on the machine was being used. After the
guilty process was killed, I was able to start the listener. FYI, the
process was
Maybe find something at http://sunsolve.sun.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting service
From the listener.log I am getting:
12-SEP-2003 11:24:20 *
(CONNECT_DATA=(SERVICE_NAME=TRADEDB1)(CID=(PROGRAM=)(HOST=trade-host2)(USER=rubix)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.8.28)(PORT=40837)) *
establish * TRADEDB1 * 12500
TNS-12500: TNS:listener failed to start a dedicated server
pro
both client and server on Sun OS 5.8
ORACLE_HOME and ORACLE_SID in .profile
tnsnames.ora
TRADEDB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = trade-db1)(PORT =
1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TRADEDB1)
)
)
INS
Which platform & version, how did you define your ORACLE_HOME and
ORACLE_SID,
did you export them, what do your tnsnames.ora and sqlnet.ora look like?
This way, I can only tell you to wait for another bus.
--
Mladen Gogala
Oracle DBA
> -Original Message-
> From: [EMAIL PROTECTED] [mail
Hi All
I am able to connect to my database from a set of different
clients from different machines.
From one particular machine i am not able to connect to the DB
server machine.
ping works fine
but tnsping gives
Bus Error (core dumped)
Please help
Thanks and Regards
__
Partitioning in itself is not a complete solution, because it doesn't keep
track
of changes. You may also want to try Princeton Softech, which has a great
product
that archives things directly to CD juke box and keeps track of what is
where and changes
needed in order to get it back online, if nece
We haven't had any problems with those here.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO
I really appreciate all replies. Those solutions are very good. I think
partition works for our case.
Nancy
From: "Stephane Faroult" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: archive old data
Date: Fri, 12 Sep 200
Prem,
You may want to check out Note# 1058332.6 for this. It appears that the
reference to Note# 52576.1 is bogus.
Good Luck!
Faan
-Original Message-
Sent: Wednesday, September 10, 2003 10:59 PM
To: Multiple recipients of list ORACLE-L
Hi List,
I don't find Doc 52576.1 (Reg. cleaning
Title: RE: _cpu_count vs cpu_count
Tanel,
33 cpu_count initial number of cpu's for this instance system modifiable
34 _cpu_count current number of cpu's for this instance non-modifiable
For most of hidden parameters x$ksppsv.ksppstvl set to 0 by default.
Alex.
-Original Me
All (in the US at least ;-) - maybe this explains it all...
http://www.nytimes.com/2003/09/12/business/12NORR.html?ex=1064030400&en=
5e8977089c9764ee&ei=5062&
John
Sorry Jared for posting this - I think we do need to understand what may be
affecting our professional lives..
-Original Messa
Roland,
There are 2 techniques you can use. The first is what I call a 'dynamic
control file' - other posters have given you examples of that one, using
sed.
The next is create a 'loop loader'; essentially a script file that fires off
sqlldr for each loadable file. Here's an overly simple example
Forgot to mention yesterday. I ran into a similar situation two weeks ago. Whenever
this happens in a SQL*Plus session, just do a "DESCRIBE PACKAGE". You should be able
to describe successfully , and verify the signature (including datatype) tallies.
Also,keep track of the session session_roles and
And for you cobol users out there:
we have been told that the bug related to setting
cursor_sharing=force
when using cobol has been fixed in 9.2.0.4.
So maybe that will help keep the 4031 bug in its box.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INE
Selling
--
Mladen Gogala
Oracle DBA
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Jesse, Rich
> Sent: Friday, September 12, 2003 12:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: OT Re: RE: What is a large database?
>
>
fastest and easiest way to do it is the following. create another tablespace with
another user. Set it to nologging.
alter session enable parallel dml;
create table /*+ parallel(max#,s) */ as
select *
from old_tablespace.table
where -- your filter.
export this new tablespace so you have a full
You're right. I made a mess of this. I'm busy, and I'll stay away from the
list
today.
--
Mladen Gogala
Oracle DBA
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Tanel Poder
> Sent: Friday, September 12, 2003 1:05 PM
> To: Multiple recipients o
Govindan,
Everything was successfully compiled. Even then the problem was happening. Your asktom note was helpful. It clarified a lot of related subjects.
We have a package and we declare a lot of application wide variables in the package (not the body). However since this problem can happe
In an ideal world, tables are partitioned and you just have to archive partitions -
either to other tables in an ARCHIVE schema, or by exporting them - and then you can
truncate them (=partitions). In the real world, you always have some rows at a very
old date which are *not* in the CLOSED stat
>From "ls -l" command.
-rwxrwxrwx
First character, the dash in this case, identifies the kind of file (in Unix
everything is a file).
The next three are the owner's permissions.
The next three are the group's permissions.
The next three are the world's permissions.
r=read
w=write
x=execute
The
Title: RE: archive old data
Hi Nancy,
Unless you are having serious performance / storage problems or another valid option would be just to delete the data, don't do it.
I inherited a database where we archive data yearly. I started working on the checklist and scripts last month and we w
Nancy,
As with so many things, it depends.
If you *might* need some of the data back, then you need to be able to
recover it. That means if you do an export, you need to know what
version it is and track whether that table ever has any changes. If it
does change, you will need to jump through m
> You are not right. SYSDBA is authenticated through the operating system.
You
> must have a DBA role
> to be a SYSDBA, be it local or remote. To allow authentication of a remote
You probably meant "SYSDBA privilege to be a SYSDBA"? DBA role is irrelevant
here.
Tanel.
--
Please see the offici
Mladen, doesn't your spell checker dictionary include
"RUMPELSTILTSKIN"?
;-)
--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> How about:
>
> SELECT 'RUMPELSTILSKIN' FROM DUAL;
>
> That should be a good guess.
>
> --
> Mladen Gogala
> Oracle DBA
>
>
>
> > -Original Message-
> > From:
http://www.bookpool.com/.x/i23de5dpw0/sm/1565924568
This will give you some of what you seek. But because of the rate that new
stuff is being crammed into Oracle, it will be a little out of date. The
web page has additional links to other pocket references.
--
Please see the official ORACLE-L
Nancy:
It's the standard answer: "It Depends".
We are running SAP, and SAP has it's own flavor of archiving, and
each transaction type has it's own archiving rules. Archived
data is stored in special files that SAP can read, so that even
though the data is no longer in the Oracle database, it i
Hello,
We are starting to investigate different methods of searching
large medical documents for key words or phrases. The documents may
be text, html, xml, or MS word documents. The main idea is to search
and retrieve a list of documents quickly that match a given medical
key word(s) or phrase(s
We have some tables that have data for many years. We are going to archive
the data that are older than 3 years. I would like to find out how you guys
usually do this or a best way to do this. Thanks for any inputs in advance.
Nancy
___
Hi!
I just noticed that there's two parameters in 9.2, cpu_count (which defaults
to number of CPUs OS says), but what is _cpu_count? It seems to be
independent from cpu_count & defaults to zero on my machine...
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: T
It's Friday evening here already. One beer for me!
:)
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 6:59 PM
> Coffe is always good. Have one for me as well.
>
> --
> Mladen Gogala
> Oracle DBA
>
>
>
> > -
Peter,
I'll answer the 2nd question first as it's easier.
- You will need to change the word size of your database from 64 bit to 32
bit. This involves running a few scripts and bouncing the database were
required. The exact process is described in a Metalink note, sorry but I
don't have the numb
It's supposed to be "mauve", the color. The reference is from a Dilbert
cartoon. Google found a copy here:
http://www-dbs.cs.uni-sb.de/~dbs02/images/dilbert.gif
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI
You can combine the files into one file, but Unix is like any other
operating system: file names must be unique. In VMS, the OS would use
versioning on the file name. In UNIX and other OSes, it doesn't happen like
that. Your syntax will combine all the files into one file.
RWB
===
Hi!
No, o7_dictionary_accessibility controls whether SYS user can log on to
database without SYSDBA privilege (starting from 9.2). If it's false, sys
always has to connect as sysdba.
Mladen, don't you think that if you have created passwordfiles for each
instance in RAC and set remote_password_fi
That's only if the file ends in .DLL :)
"Mladen Gogala"
Coffe is always good. Have one for me as well.
--
Mladen Gogala
Oracle DBA
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Brian Dunbar
> Sent: Friday, September 12, 2003 11:24 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Questio
Stephen,
Surely, you must be mistaken. I just finished reading the Oracle 10G
article in the latest Oracle magazine about how they "regression test" every
little change made to the Oracle Rdbms code to ensure that bugs do not make
it out into production.
It *can't be* their fault. It *has to be
You are not right. SYSDBA is authenticated through the operating system. You
must have a DBA role
to be a SYSDBA, be it local or remote. To allow authentication of a remote
user as a sysdba, you
must explicitely tell oracle to do so. Dictionary accessibility has nothing
to do with that.
--
Mladen
Hey!!!
don't do that!
send me $50!... I can create your account too! of
course, at the same place!
:-)
JL
--- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> Send me a check to $100 and I'll create you username
> on
> http://technet.oracle.com that will
> make it possible for you to reach the reques
This is not true. If O7_DICTIONARY_ACCESSIBILITY is set true, the instance
can be connect as sysdba from remote if user has granted role sysdba. Am I
right?. If this value is true. even then sys can be connected as normal
user.
With Regards,
Manoj Kumar Jha
C-56 , Phase-2
NOIDA -201305, UP(INDIA)
There is a known bug in Oracle's handling of the shared pool in 9.2.0.X (at
least) where the shared pool becomes increasingly fragmented and eventually
gets to where no more space can be allocated. Attempts to flush the shared
pool to clear it fail (Yes, I know this means everything has to be
re-
I don't recommend setting any hidden _* parameter just because someone
thinks it's neat or it has once worked form someone.
If you got a problem, which isn't solvable by any other mean, then turn to
underscore parameters or other unsupported actions...
Tanel.
- Original Message -
To: "Mu
Thanks, Tanel. You always provide good solution.
From: "Tanel Poder" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: 9.2.0.4 anyone
Date: Fri, 12 Sep 2003 07:14:24 -0800
It's a hidden parameter, use this query instead:
se
Mladen is losing patience with all questions simple.
-Original Message-
Sent: Friday, September 12, 2003 11:24 AM
To: Multiple recipients of list ORACLE-L
Mladen Gogala [mailto:[EMAIL PROTECTED] on Friday, September 12, 2003
9:19 AM said;
> 3 different files, having the same name in th
Title: RE: Copying statistics : used a lot
Our production and test systems are same ... test lags 24 hours behind production that's all. But I have successfully used dbms_stats to copy over stats from production to test on a table by table basis to verify explain plans.
My opinion WAD -
Mladen Gogala [mailto:[EMAIL PROTECTED] on Friday, September 12, 2003
9:19 AM said;
> 3 different files, having the same name in the same directory? Only
> Microsoft
> can do that, but only if you buy "enterprise wide license" for Windows,
> Exchange and SQL*Server.
(blink) is that an example of
Yes, I saw it.
NT Server 4, IIS4, connecting to Oracle 8.0.4..
Patrice.
-Original Message-
Sent: Thursday, September 11, 2003 5:49 PM
To: Multiple recipients of list ORACLE-L
Have you tried the kb?
http://support.microsoft.com/default.aspx?scid=fh;EN-US;kbhowto&sd=MSDN&ln=E
N-US&FR=0
It's a hidden parameter, use this query instead:
select n.ksppinm name, v.ksppstvl value
from x$ksppi n, x$ksppsv v
where n.indx = v.indx
and n.ksppinm = '_kghdsidx_count';
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September
Is this for all platforms? I haven't heard about it for AIX5.2 but that
doesn't mean I shouldn't apply it.
Thanks in advance,
Ruth
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Stephen Lee
Sent: Thursday, September 11, 2003 5:29 PM
To: Multiple
How can I not see the init parameter, _kghdsidx_count in 9.2.0.3.0?
From: "Tanel Poder" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: 9.2.0.4 anyone
Date: Thu, 11 Sep 2003 17:54:30 -0800
Hi!
> Oh yeah, I forgot to say th
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/toc.htm
--
Mladen Gogala
Oracle DBA
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Veeraraju_Mareddi
> Sent: Friday, September 12, 2003 10:44 AM
> To: Multiple recipients of li
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] on Friday,
September 12, 2003 6:59 AM
> Hallo everyone,
> I have a unix question, hope you can help me. Maybe this is too simple but
would appreciate any help.
> I would like to rename the files
konkurrenter.txt.1,konkurrenter.txt.,,konkurrenter.txt.3
If you can't do a chmod 755 XXX, then you can´t do this ... you don't have
enough privileges...
Do a su root (if you can), or ask the owner of the files to do the chmod ...
BTW, Chmod 755 isn't enough, I think you need a 777 ... (my chmod numbers
are a little hazy)
(is this an oracle related ques
Dear All,
Please share / url for a good document / presentation explaining different
locking mechanism in Oracle , and Oracle DBA reacts to each kind of lock ,
with some scenarios.
Please post any relative material.
TIA,
Rajuveera
***
Thanks for the response. I have Metalink note 231901.1 which explains
the options for installing 8.1.7 on AIX 5L, so I understand what I have
to do (after reading it three times).
Additional questions:
- If we run the 64 bit kernel and put on the required patch for 8.1.7
will I be running Oracle
Well no, I have bought the Expert one on one book.
I check on his web site and I found one reference where he addresses the use
of changing the stats.
Usually you can find what is its opinion just by the tone, but this time I
was not able to see if he's against or not on this.
Can you share more
Hi.
Just wanted to thank all who replied to my original
question. I was only looking for one way and I got
several from different people (which is great) within
just a few hours. Thanks you all very much!!!
Gene
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-
3 different files, having the same name in the same directory? Only
Microsoft
can do that, but only if you buy "enterprise wide license" for Windows,
Exchange and SQL*Server.
--
Mladen Gogala
Oracle DBA
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Beh
Title: Message
You
should set remote_os_authent and remote_os_roles to true, otherwise
RMAN will not be able to connect to the remote isntance as
sysdba. On the other hand, you might want to reconsider it, because that
would open your instance wide to the various forms of
network
attacks.
Send me a check to $100 and I'll create you username on
http://technet.oracle.com that will
make it possible for you to reach the requested information at any given
moment.
--
Mladen Gogala
Oracle DBA
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf
Hallo,
anyone whom could help me with a unix command how to
give permission to delete files from a special directory?
I am trying to use chmod command but it doesnt work with chmod 755
It says permission denied then.
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ: http://ww
If MS means Micros**t, our Techs have been applying patches like crazy to
all our Win2k servers. Our production Student Info. database lives on one
of those - it's EE 8.1.7.4 - and I've seen no ill effects. We just had to
find a time to reboot the server so the patches would "take effect".
Jack
Hi All,
Has anyone heard of any known gotchas with installing the latest MS patch
on Oracle server?
Thanks
Rick
--
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 Dieg
If konkurrenter means competitor, they have nothing to fear.
>- --- Original Message --- -
>From: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Fri, 12 Sep 2003 03:59:25
>
>Hallo everyone,
>
>I have a unix question, hope you can help me. Ma
> Hi Tanel
>
> I did not mention that w/o the connect string it works
Try to log on as sysdba with bogus password (without connect string), you
should be able to log on anyway, because you're in os dba group.
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tan
Title: RE: Good & small reference !
If you want to memorize all of things you mentioned, get at-least an yearlong sabbatical and stay away from this material world.
Jokes aside, don't try that, there is no need. Oracle provides manuals just for the very reason.
Raj
-
At 03:34 12/09/2003 -0800, you wrote:
Thanks
Bill - not good news, then!
Trouble is, I'm setting up a
bunch of "read-only" userids which can see (but not touch)
tables in several other schemas. So instead of doing all the grants with
a single connect (as SYS), evidently I'll have to connect as e
Hi Tanel
I did not mention that w/o the connect string it works
Will look at the password file.
I have not tried to run a query in SQL*Plus, will ask the cst to do so.
I use a new user for the repository (not apps)
Jack
-Original Message-
Sent: Friday, September 12, 2003 1:49 PM
To:
$ORACLE_HOME/rdbms/admin
and documentation
happy reading.
joe
Veeraraju_Mareddi wrote:
Dear Friends,
I am looking for a good reference of all ( some which are very much useful &
required for DBA ) the SQL scripts ,packages and all required views.
UTL*.sql ,
DBMS_*
DBA_*
V$*
I just want to mem
Hallo everyone,
I have a unix question, hope you can help me. Maybe this is too simple but would
appreciate any help.
I would like to rename the files
konkurrenter.txt.1,konkurrenter.txt.,,konkurrenter.txt.3 to be renamed to
konkurrenter.txt at the same time.
So the result would be 3 files, ev
Raju,
Have you tried the 'Oracle 8i Reference Guide' for DBA_*, V$*
views, and 'Supplied packages Reference' for DBMS_*, UTL_*? (If
you have, you would do well to mention so, to send right signals
to some of the list members.)
If you are looking for the source code for the supplied packages,
you
Title: Connect sys/[EMAIL PROTECTED] as sysdba & E-Business suite
Hi!
Are you sure that you have correct password file in
second instance?
Maybe you're using wrong password (or do not have
pwdfile) buf on first instance you just belong to os DBA group, thus you can log
on using whatever pas
Raju,
SQL> select * from dictionary;
this will give u list of dictionary views/tables.
...no idea about the scripts though.
Jp.
12-09-2003 20:19:25, Veeraraju_Mareddi <[EMAIL PROTECTED]> wrote:
>Dear Friends,
>
>I am looking for a good reference of all ( some which are very much useful &
>requ
Thanks a lot Tanel and GovindanK for answering to my query.
With Warm Regards
Siddharth
Haldankar
Cisco Systems Inc. ODC
Zensar Technologies
Ltd.
# : 4128374
[EMAIL PROTECTED]
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROT
Thanks
Bill - not good news, then!
Trouble is, I'm setting up a bunch of "read-only" userids which can see
(but not touch) tables in several other schemas. So instead of doing all the
grants with a single connect (as SYS), evidently I'll have to connect as each
schema-owner in turn, and is
Hmm, applied Feng Shui for Oracle Performance.
For optimum throughput storage should be coloured red and white in
alternating bands of colour.
It's called disk-striping.
Badummp-k !!
I'll get me coat ... and back on topic.
Mike
-Original Message-
Sent: 12 September 2003 11:14
T
not until the 9i world, you must login as the schema owner or build a
procedure to be able to do it.
joe
Paul Vincent wrote:
Hi,
I'm trying to grant SELECT privileges on some tables in schema X to
userid Y. I'm currently connected as SYS. But when I try typing
GRANT SELECT ON X.MYTABLE TO
http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage
Reference:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/toc.htm
Supplied PL/SQL Packages and Types Reference:
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/toc.htm
Have Fun! That's some memo
Dear Friends,
I am looking for a good reference of all ( some which are very much useful &
required for DBA ) the SQL scripts ,packages and all required views.
UTL*.sql ,
DBMS_*
DBA_*
V$*
I just want to memorize the important of above. Any document, PPT or white
paper or any URL will be helpful.
LOL, Mauve is a shade of the colour Purple.
And of course, everybody knows that purple databases run faster! ;)
Personally, I've always preferred Electric Blue databases, funky, fast, and
FAR easier to manage!
-Original Message-
Guido Konsolke
Sent: 12 September 2003 08:54
To: Multiple
At 02:49 12/09/2003 -0800, you wrote:
Hi,
I'm trying to grant SELECT
privileges on some tables in schema X to userid Y. I'm currently
connected as SYS. But when I try typing
GRANT SELECT ON X.MYTABLE TO
Y;
...I get an ORA-01031 error -
Insufficient Privileges.
Now I thought SYS had all th
you should send them over to Australia. At least they'd be
better than the standard of "dba" we get here...
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
> In Estonian language, the word "administrator" also means receptionist.
> Guess how many former hotel receptionists or w
Title: RE: Migrating RMAN catalog database to 9.2.0 and supporting 8.0.6
Hi,
I'm
trying to grant SELECT privileges on some tables in schema X to userid Y. I'm
currently connected as SYS. But when I try typing
GRANT
SELECT ON X.MYTABLE TO Y;
...I
get an ORA-01031 error - Insufficient
Title: RE: Migrating RMAN catalog database to 9.2.0 and supporting 8.0.6
Was
able to upgrade the catalogs as getting "catalog too old error" and found great
note and compatiblity matrix:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=73431.1
How
1 - 100 of 108 matches
Mail list logo