For V$Views definitions have a look at catalog.sql, which has some
information. I understand by D$tables, you mean the dictionary tables.
If that is the case, the sql.bsq (under the $ORACLE_HOME/rdbms/admin)
will be of use.
KG
=
Have a nice day !!
Thank you very much.
santosh
-Original Message-
Gopalakrishnan
Sent: Friday, January 17, 2003 1:19 PM
To: Multiple recipients of list ORACLE-L
For V$Views definitions have a look at catalog.sql, which has some
information. I understand by D$tables, you mean the dictionary tables.
If
As I have found to my cost when you have a database with long columns forget
about 90% of Oracle newer functionality.
Sqlplus copy is the best workaround (other than exp/imp)
Here is a example script
set long 4000
set array 5000
copy from user/password@ to user/password@ -
insert
Do you have 'EXECUTE CATALOG' previllege ?
1. Views
OWNER NOT NULL VARCHAR2(30)
VIEW_NAME NOT NULL VARCHAR2(30)
TEXT_LENGTH NUMBER
TEXT LONG
TYPE_TEXT_LENGTH
Hi,
how can I calculate/estimate the extra disk space I'll need if I
change the log mode from non-archive-mode to archive-mode. I want to change
the log mode of all my objects. Do I need to do this one-by-one or is it
enough if I change the log mode of my tablesapces?
Thanks in advance
Title: RE: Database tracking
Are you willing to share the solution with
us ?
George
George
Leonard
Oracle Database
Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Cell: (+27) 82 655 2466
Tel:(+27 11) 575
0573
an incremental export does not export just the new rows but ALL the
data in the table. It will, however, only export if there has been a
change to the table, thus the incremental
--- Krishna Kakatur [EMAIL PROTECTED] wrote:
How about using incremental exports/ imports?
HTH, Krishna
-
What is the MAX possible Length of of Name for Table / Index ?
Why ?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California--
I stand corrected.
thanks Robert.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, January 16, 2003 3:20 PM
To: Multiple recipients of list ORACLE-L
RMAN does no compression on any blocks with data. The only compression that
occurs that blocks above the
I am considering the appropriate way to do database corruption prevention.
Should I use one or more of the following as a proactive measure ?
a) Export
b) DBVerify
c) Analyze table table_name validate structure cascade
Any advice ?
Thanks,
PH
We are using automatic undo management and automatic memory management (pga
aggregate target) both with much success.
-Original Message-
Sent: Thursday, January 16, 2003 5:45 PM
To: Multiple recipients of list ORACLE-L
Hi lister:
Just want to know how well you adopt those 9i new
Plus incremental exports/imports are depreciated in 9i and, though I'm not
sure,
will probably go away in 10i.
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on
http://tahiti.oracle.com
Look
in Database Reference Guide.
Or if
you have Rich Niemiec's book (Performance Tuning Tips Techniques... etc..)
there are a number of pagesshowing the output from 'describe' ofmany
of suchviews.
-
Kirti
-Original Message-From: Santosh Varma
I am considering the appropriate way to do database
corruption prevention.
Should I use one or more of the following as a
proactive measure ?
a) Export
b) DBVerify
c) Analyze table table_name validate structure
cascade
Any advice ?
Thanks,
PH
Pui Ho,
The only way you can be
1)
SVRMGR create table A2345678901234567890123456789012345 (c number);
create table A234567890123456789012345678901234567890 (c number)
*
ORA-00972: identifier is too long
SVRMGR !oerr ora 972
00972, 0, identifier is too long
// *Cause: An identifier with more than 30
Speaking of Select, cudo's to Jared for the article on Perl in the recent issue.
I gave it the once over last night then marked it for a more detailed read.
Just might have to learn it!!
Dick Goulet
Reply Separator
Author: Ferenc Home [EMAIL PROTECTED]
These correspond to the Oracle background processes. Look at V$PROCESS for
the specific information on what is executing.
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
I would do all three. A good backup stategy is only good if you read all
your data all the time. You can have corrupt data that doesn't get read and
doesn't cause a problem for weeks, month, years. By that time you have no
backup that does not contain corrupt data. Export to a null file to
Murat,
The estimate of amount of space for archive logs come from your redo log
switch. If you have placed the init.ora parameter log_checkpoints_to_alert
set to TRUE, then your alert log file will have lines when the redo log
group switch fom one to the other. That will give you a rough idea of
(d) All of the above
i) Export to /dev/null will go through all the fields of all the tables, all
the rows, but will not scan indexes
ii) Dbverify will scan for block corruptions but not logical corruptions.
iii) Analyze will check for table-index logical corruption.
Practically, you could just
We use the automated PGA space management, automated MTTR managemsnt,
segment level stats, ausotmatic undo, automatic segment space management and
list partitioning features predominantly; and they work like a charm.
Arup
- Original Message -
To: Multiple recipients of list ORACLE-L
The why is related to the data dictionary...
-Original Message-
Sent: Friday, January 17, 2003 7:04 AM
To: Multiple recipients of list ORACLE-L
1)
SVRMGR create table A2345678901234567890123456789012345 (c number);
create table A234567890123456789012345678901234567890 (c number)
That was the first check I did. And all my temp tablespaces are of
TEMPORARY type only.
I did lot of reasearch on metalink and I found there are some issues with
8.1.7 in this regard. I got this suggestion from metalink only.
-Original Message-
Sent: Thursday, January 16, 2003 4:52 PM
To:
Also, RMAN can do incremental backups, copying only the blocks that changed since last
backup. More about all this in Oracle Manuals and in Robert's book.
- Kirti
-Original Message-
Sent: Thursday, January 16, 2003 10:04 PM
To: Multiple recipients of list ORACLE-L
Maria -
Title: temp space
anyone know how to identify the session that caused a ORA-1652?
-thank you
Just use RMAN to backup your databases. It will warn you about corruptions.
Raj
Stephane
Murat,
Whether your in archive log or no archive log mode is a database wide thing.
It is not set at the tablespace or object level. As for how much disk will you
need, connect to the database with svrmgrl or SQL*Plus as sys and issue the
archive log list command. Take the oldest online log
Hey
guys-
Have any of you all
messed around with the silent install/response files? I'm looking for
tips, advice, do's, don'ts,etc,etc
TIA
Greg Loughmiller
Sr Manager - Enterprise
Data Architecture gloughmiller (IPS) 678.893.3217 (office)
We had a corrupt index block which caused an ORA-600 which was not noticed
and eventually brought down the database.
We do lots of checks now. (d) All of the above.
R. Smith
-Original Message-
Sent: Friday, January 17, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L
(d) All of
No need to do any of this if you are using RMAN. With each backup, RMAN
checks each block backed up for any corruption. Corruption will be reported
and you
can opt to allow a certain amount of it or none.
Rf
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts
this sounds weird,
but i heard that installs will not work via terminal services for 8.1.7
good luck,
steve
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/16/2003 09:08 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Pui Ho,
Stephane raises a good point, unfortunately, many operations groups
stop at the backup. It is not the responsibility of operations to backup the
database/system. It is the responsibility of operations to recover the
database/system. There are many stories of backups that execute
They are 30 characters, each.
Why? Well, there has to be some limit on the length. 30 seems an ok number.
While designing the table names, anything more than 30 chars seems a bit
difficult to digest. But then again, Oracle should have given the option to
use a longer name, too. Particularly in
If I use Replication such as:
create materialized view EMP
storage (...)
tablespace ...
refresh fast
start with sysdate next sysdate+1
as
select * from emp@remote_connect;
1) I am bringing the new emp data over from the remote_connect database?
2) This is a materialized view with a local base
Title: RE: Database Verification
FWIW:
The other answers have been correct as to what to do to check for corruption.
As far as preventing it?? I don't know of a way you can PREVENT it from happening. When it happens, it's usually something out of your hands (bad hardware, glitch in OS,
'A234567890123456789012345678901234567890'
The table name should not exceed 30 Characters...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 17 Jan 2003 06:58:57 -0800
The why is related to the data dictionary...
I'm signed up am looking forward to attending it!
Larry Elkins
List:
I'm touching iAS for the first time ever. I don't
understand even basic stuff about it.
The install I have includes 9.0.2 and 9.0.3. The
install says 9.0.3 is the first J2EE 1.3 compatible
release of Oracle9iAS. ..blah blah.. Oracle9iAS
9.0.3 contains only the J2EE and Web Cache
Title: RE: HOTSOS Symposium
I will be there, looking forward to meeting you, won't be staying at the
hotel since I live in Dallas.
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16,
2003 10:29 PMTo: Multiple recipients of list
Title: RE: Database tracking
Yes.
Stay tuned... about 2-3 months.
-Original Message-From: Leonard, George
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 17, 2003
2:24 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Database tracking
Are you willing to
share
We are thinking of upgrading some of our windows databases (NT 4) to 9i.
We may be upgrading the OS to w2k also. The databases are small
applications and don't require much maintenance.
What are people's experience with 9i (9.0.1 and 9.2) on windows? We are
mostly concerned with the stability of
Use Rman.
Rman automatically detects and reports corrupt blocks.
right Robert? :)
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, January 17, 2003 7:28 AM
To: Multiple recipients of list ORACLE-L
I am considering the appropriate way to do database
If I recall correctly, RMAN checks for corruption.
-Original Message-
I am considering the appropriate way to do database corruption prevention.
Should I use one or more of the following as a proactive measure ?
a) Export
b) DBVerify
c) Analyze table table_name validate
From: dist cash [EMAIL PROTECTED]
Date: Wed, 15 Jan 2003 07:23:54 -0500
Subject: [Q] SMON take too much time to clean up?
we have ORACLE 8.1.7 on NT server and this erver only run ORACLE
application. Sometime the server will have 100% CPU usage form 20 minutes
to couple hours. In that time No
I'm working with a couple of IBM gals(don't you all get offended) who
are asking about shareplex, i've not used it and have no idea whether
its good or not(or for that matter what its purpose is).
Anyone enlighten me.
thanks, joe
Joseph S Testa
Chief Technology Officer
Data Management
You could use COPY command. Create a new table exactly as the old table in
the new tablespace from the DDL scripts. Then use the COPY command to insert
rows. It lets you control the commit frequency; something impossible in
export/import.
HTH.
Arup
- Original Message -
To: Multiple
/start of plug
so does Oracle9i DBA 101 and it explains them too
/end of plug
I'm so ashamed, it won't happen again
--- Deshpande, Kirti [EMAIL PROTECTED] wrote:
http://tahiti.oracle.com
Look in Database Reference Guide.
Or if you have Rich Niemiec's book (Performance Tuning Tips
We also had a contribution on SLAs from the DBA Goddess of the list. It's
great to see the list members in print!
-Original Message-
Sent: Friday, January 17, 2003 7:04 AM
To: Multiple recipients of list ORACLE-L
Speaking of Select, cudo's to Jared for the article on Perl in the recent
It depends on how much data is changed in the database. If there is no data
manipulation, then you need very little archive space (just enough for the
online logs when you run a backup). Look in the alert log to see how many
log switches occur. I think this will give you a reasonable estimate
Darn !!
The cut paste ate up a few chars in that 'create table' line.
But you get the picture ;)
- Kirti
-Original Message-
Sent: Friday, January 17, 2003 8:04 AM
To: Multiple recipients of list ORACLE-L
1)
SVRMGR create table A2345678901234567890123456789012345 (c number);
Quest Shareplex is a replication software.
Nick Wagner from Quest is on this list and he is been very helpful
and I am sure he will be glad to provide you info on it. Right Nick? :)
-Original Message-
Sent: Friday, January 17, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
I'm
I've heard rumors of people getting it to work.
Some have claimed they have.
When asked to share their response files, I received nothing.
I once spent several hours attempting to setup a working
response file. No joy.
It's in the same class as bigfoot: several sightings, but the
only photos
Robert,
Surprising
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
When did you join TUSC? It looks that all guru's are joining TUSC.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Not a problem...
I have not bought your book yet... :(
And I *would* expect more useful information in your book, than just 'describes' ;)
- Kirti
-Original Message-
Sent: Friday, January 17, 2003 10:11 AM
To: Multiple recipients of list ORACLE-L
/start of plug
so does Oracle9i
That's the one I had in mind.
It was from Steve.
Jared
Reardon, Bruce (CALBBAY) [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/16/2003 03:59 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE:
Sympathies are in order. Prior to September, 2002 I'd never touched the
pesky thing. $WORK send me to the 9iAS (R2) course, after which of course
it was decided we'd stick with R1 until the Fat Lady sings. I'm still
groping, trying to figure out why the consultants and developers set things
up
Though you might like to see these comments from
a relative newcomer to the list:
-
I only came across this list a month or so ago and i can't tell you how
much i've learned.
this list has honestly renewed my interest in the profession and instead
of just getting
the job done, I suddenly
Title: RE: Database Verification
Some
of our users installed OEM on their local PC's. They connect to the
database through DBA Studio.
Is
there any way to prevent DBA Studio connections to the server? I am
thinking of using on_logon trigger but no clue how to catch the
connection.
Any
It's a maybe for me.
Waiting for the execs to finalize our budget.
Jared
Larry Elkins [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/16/2003 04:19 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
I have a very clunky way of calculating the # of minutes in shell since
2000. This allows me to write the value to a variable and then do the math
later in a script to figure out how long a job ran, an alert has been
trigger etc...For those of you working in shell you know date math is not so
It lets you control the commit frequency; something impossible in
export/import.
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76955/ch02
.htm#40480
COMMIT
Default: N
Specifies whether Import should commit after each array insert. By default,
Import commits only after
Title: RE: from Non-Archive-Mode to Archive-Mode
I personally use the following SQL to
get a very rough estimate of how much
archive space I'm going to need per day.
select (num_logs*bytes )/(1024*1024) Megs per Day
from (select ceil(avg(count(*))) num_logs from v$log_history lh
group
I need two files (Imp.exe and exp.exe) for Oracle 8.1.5 on
Windows NT 4.0.
If someone have. Please send for me.
Thanks.
--
Breno A. K. Magnago mailto:[EMAIL PROTECTED]
Mercantil de Alimentos Soares
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Breno
Barb,
I've been deploying forms over the web since OAS 4.07 and I had
Oracle WebServer experience going back to version 2. What I found
was that knowing all of that stuff made it worse for trying to
figure out 9IAS Rel 2 (9.03). What further complicates it (web
forms that is) is that if you read
Title: RE: quest shareplex
It allows for master to master replication. My understanding is that Oracle's Data Guard now does the same thing. Shareplex was faster then replication with less latency because it would read from the online redo files from Oracle. I understand that Data Guard now
And also an article about Summary Table Mgmt from Arup Nanda :)
Kudos to all !!
- Kirti
-Original Message-
Sent: Friday, January 17, 2003 9:19 AM
To: Multiple recipients of list ORACLE-L
We also had a contribution on SLAs from the DBA Goddess of the list. It's
great to see the list
Installing via terminal services doesn't work because
it is actually a remote session. A term services session
is not on the console, much like using telnet or ssh.
Jared
Stephen Evans [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/17/2003 08:14 AM
Please respond to ORACLE-L
[EMAIL PROTECTED] wrote:
Some of our users installed OEM on their local PC's. They connect to
the database through DBA Studio.
Is there any way to prevent DBA Studio connections to the server? I
am thinking of using on_logon trigger but no clue how to catch the
connection.
Any
Title: RE: Database Verification
Rao,
why? why prevent them from using a
tool?
do
they have privs to do anything? if so, then you have bigger
problems.
the
tool is never the issue. the issue is what database account they are using
to connect with. if they have privs to change objects,
We are running into an issue here and I wanted to check to
see if anyone has encountered it.
We are getting a Windows Event Viewer message stating an
Oracle Catastrophic Failure.
It seems to be centered around the Oracle
Services for Microsoft Transaction Server component.
I am running
Raj,
You can of course compute the average any list of numbers. However, if
your list contains data from fundamentally different types of data, then
your average will be meaningless. Example:
A = {Response times for program 'a'} = {20:58.13, 42:19.28, 34:11.23}
B = {Response times for program
Bill,
A rollback will generate redo, so that it can be recovered. If a
system crashed during a rollback, the database must be able to recover to
the point at which the rollback had terminated. Since a rollback is applying
the undo records (think opposite actions), it is modifying data, so
Arup,
From your past replies to the list, I am surprised to hear you say this.
If you have placed the init.ora parameter log_checkpoints_to_alert set to
TRUE, then your alert log file will have lines when the redo log group
switch fom one to the other.
Regards
Raj
Chris,
Add the following in your init.ora. event = 1652 trace name errorstack
level 3. And check the user dump destination after u encounter the error.
In case, downtime is not an option, or you cannot set it at the individual
session levels , another way of doing it is by coding for a
I'd have to agree w/Jared, its more like vaporware ;)
joe
I've heard rumors of people getting it to work.
Some have claimed they have.
When asked to share their response files, I received nothing.
I once spent several hours attempting to setup a working
response file. No joy.
Greg,
If you are upgrading to Oracle 8.1.7.4 on a hp-ux server without an X-term
and trying to use silent install to get around it, don't do it. A DBA I work
with was trying to do it and ran into issues. I researched it on metalink
and found a thread that listed 3 bugs associated with this
Title: RE: quest shareplex
I was going to keep quite... but here goes. :)
-
Yes, of course I'll be glad to help.
Basically...
Log Based replication for Oracle. A capture process continually reads the online redo logs and parses out
Dennis,
Have you used the script ??
I have gone thru the material u have pointed , also executed the script in
it, but it doesn't make any sense to me . Performance is the issue for me
not the SPACE .
here is the script:
- pctused.sql
- © 1999 by Donald Keith Burleson
set heading off;
set
Title: RE: Database Verification
They cant use it unless they can
select from the data dictionary views. For example, if they dont the
SELECT_CATALOG_ROLE role or DBA privs in 8.1.7 they
can not use DBA Studio.
Todd
-Original Message-
From: [EMAIL PROTECTED]
But the fundamental question is why prevent them.
What damage are they causing?
Control their actions via proper permissions.
If OEM installation is against Company policy (or they did not ask the Oracle DBA
Group), then the problem should be addressed via other administrative procedures.
-
Just idea, how about:
SQL select 24*60*(sysdate - to_date('00-00-00-01-01-2000',
'SS-MI-HH24-DD-MM-') ) from dual;
24*60*(SYSDATE-TO_DATE('00-00-00-01-01-2000','SS-MI-HH24-DD-MM-'))
--
Anybody know thats ORA
ORA-24333?
look:
oerr ora 2433324333, 0, "zero iteration
count"// *Cause: An iteration count of zero was specified for the
statement// *Action: Specify the number of times this statement must be
executed
When thats issue occur?
thanks
Adriano
Title: RE: Database Verification
They
may have'select any table' privilege :)
-
Kirti
-Original Message-From: Todd Carlson
[mailto:[EMAIL PROTECTED]]Sent: Friday, January 17, 2003 1:10
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Limiting user connections with DBA
Hi Larry,
I am attending. Wonder who else on the list is attending.
Regards,
Denny
Quoting Larry Elkins [EMAIL PROTECTED]:
Listers,
Just curious if anyone from the list will be going to the HOTSOS
Symposium
in Dallas on 2/9 thru 2/12? It sounds like it should be pretty good,
but
Yeah that would work if I want to use the database but I try to write things
in such a way that I can use them in other places and share them with other
non-DBA types, thus the reason I am not using Perl or GNU date. Oracle-L
has some very good *nix scripters so that is why I posted it here, I
Title: RE: Database Verification
Todd,
The
previous DBA has granted them almost all the privileges except DBA
privilege. Now, when we tried to take away this SELECT_CATALOG_ROLE, then,
these specific users started raising alarms.
So,
what we are planning is to kill their session the
Thank You for your response Cary. You say The important thing is that you
have to segment your transactions into different lists. I did convey
something similar to the requestor. I have now put the ball back in their
court, by telling them to identify some crucial functions or precise
statements
Is there a way to order the result set of a query by date chronologically?
For example, I run a usage report for customers either monthly, quarterly,
semi annual or annually. I need to return the result set chronologically by
month and I cannot seem to find a way to do it.
Thanks for any help!
Reddy - No I have not used that script. But most of Don's stuff is quite
good. I thought it might illuminate some issues for you. Sorry if it didn't
help.
The PCTFREE and PCTUSED parameters mainly need tweaked when your data is
volatile, when existing rows are updated with additional data. Is
Adriano Freire wrote:
Anybody know thats ORA
ORA-24333?
look:
oerr ora 24333
24333, 0, zero iteration count
// *Cause: An iteration count of zero was specified for the statement
// *Action: Specify the number of times this statement must be
executed
When thats issue occur?
Arn - I don't know if this will help, but since I don't see where you've
received any replies, you might take a look at a new Oracle9i feature,
Database Workspace Management.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 16,
Hey what can I say, I am a ksh bigot :)
-Original Message-
Sent: Friday, January 17, 2003 2:52 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
any more, a system without perl is hardly a system at all.
it's kind of like a system without a shell.
Jared
--
Please see the
On an ordinary insert, you get a redo record for
the row, and the undo (rollback) for that row.
You also get a similar record for each index
that has to be updated because of the new row.
Similarly, an update or delete will generate one
redo record for the table, and one redo record
for each
Since the redo log contains only details about
object id, row location, and changed values , how
do you derive a table-name and key value for
the SQL to be applied ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based Optimisation
(see
Dennis,
My database is of size 960 Gig for now and its a heavy OLTP with high DML
activity on tables , we are observing some ORA-00600 errors these days due
to chained rows in the tables . Also we all know chained rows cause
performance issues . I wanted to fix this ASAP and also would like to
What I've done, is I have some PL/SQL code which looks for chained rows.
When the number of chained rows exceeds 5% it proceeds to unchain the rows.
Upon completion it increases the PCTFREE by 5% decrease PCTUSED by 5%.
This process continues until they reach values which don't induce chaining.
Title: RE: Database Verification
You should kill the previous DBA too. ;-)
Todd
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, January 17, 2003
2:24 PM
To: Multiple recipients of list
ORACLE-L
Subject:
Sebastian,
I dont know if I understood this right, for this seems to be quite a simple
task. Or maybe I am overlooking something very obvious.
Select to_char('date field','MMDD') from Mytable
order by 1
Unless you dont want the date field displayed in that format in your
report, but still
Thanks, Kirti.
Arup
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, January 17, 2003 1:08 PM
And also an article about Summary Table Mgmt from Arup Nanda :)
Kudos to all !!
- Kirti
-Original Message-
Sent: Friday, January 17,
I agree with Kirti. Why prevent them from using DBA Studio? If you have
given them the privilege, then they can easily connect through sql plus or
some other tool, not necessarily through DBA Studio. So it's better to
control their actions through proper grants.
Arup
- Original Message -
1 - 100 of 117 matches
Mail list logo
