Title: RE: Date format is unreadable
to_date('01/01/1970', 'MM/DD/') + time_stamp / 86400
is a DATE expression
formatting of DATE values is done with the TO_CHAR function (see SQL Reference Manual)
for example:
to_char (to_date('01/01/1970', 'MM/DD/') + time_stamp / 86400,
Title: RE: Anyone looking fora Developer/DBA in Wash DC area?
This site explains some of the details on how to get a security clearance.
http://www.taonline.com/securityclearances/scdetails.asp
If you want to get one your employer has to apply for you.
It can help you get jobs for a
Title: RE: remote / as sysdba
As far as I know, it works like this:
You will need to set init parameter REMOTE_LOGIN_PASSWORD_FILE to EXCLUSIVE.
You then can sign on as SYS remotely, or as another user remotely if the other user has SYSDBA. See the users that have SYSDBA or SYSOPER in
Title: RE: show errors doesn't show anything ???
-Original Message-
From: Janet Linsy [mailto:[EMAIL PROTECTED]]
I have 9i on Linux Red Hat 2.4.9. A package is
invalid after compiling. I did a show errors but
nothing shows. How do I see where the error is ??
SQL alter
?
__
__
*** Original message by Jacques Kilchoer [EMAIL PROTECTED]
As far as I know, it works like this:
You will need to set init parameter
REMOTE_LOGIN_PASSWORD_FILE to EXCLUSIVE.
You then can sign on as SYS remotely, or as another user
remotely
Title: RE: System tablespace Oracle 9202
Metalink Note:175434.1 has some interesting information on the subject.
For example, it reminds you that if the SYSTEM tablespace is LOCAL, then you cannot create a tablespace with extent management DICTIONARY.
You can tell the database creation
Title: RE: remote / as sysdba
I forgot that you could do that. I never liked remote os authentication (is it still possible to easily fool a client into thinking you're someone else?), and I would like it even less if it allowed you to sign on as SYSDBA without a password. The best security
Title: RE: remote / as sysdba
Thank you for the information. I thought the security issues were more fundamental. For example if my database has remote os authentication (with prefix OPS$), and I know that there is a user called OPS$JSTILL, then I can change the Windows Registry on my client
Title: RE: Question related to security
Only UserA can grant access on a table belonging to UserA (unless another user was granted access with admin option.)
However, UserB can create a procedure in the schema of UserA if UserB has CREATE ANY PROCEDURE system privilege.
The procedure created
Title: RE: access to oracle $ tables in 9.2.0
O7_DICTIONARY_ACCESSIBILITY was an init parameter as far back as 8.0, but in 9.0 and above the default has changed to FALSE instead of TRUE. Which is why, by default, you cannot read any table owned by SYS.
System privilege SELECT ANY DICTIONARY
.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jacques Kilchoer
Only UserA can grant access on a table belonging to UserA (unless another user was granted access with admin option.)
However, UserB can create a procedure in the schema of UserA if UserB
Title: RE: Fine Grained Access Control (FGCA)
If by fine-grained access control you mean what I call row-level security, then here is a proof-of-concept that I adapted to show 1 function for two different policies on two different tables.
SQL create table mug
2 (mug_id number,
3 mug_shape
Title: automatic segment-space management and pctfree
The documentation says:
(Oracle9i SQL Reference, Release 1 (9.0.1), Part Number A90125-01, ALTER TABLE)
For segments with automatic segment-space management, Oracle ignores attempts to change the PCTUSED setting. If you alter the PCTFREE
?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Title: RE: Script to Turn Off All Oracle Auditing Options?
To create the audit trail views, run cataudit.sql.
To delete the audit trail views, run catnoaud.sql.
To find out which are the active options, use this statement:
SELECT * FROM sys.dba_priv_audit_opts;
or for audit options on a
a database here with about 600 Oracle users defined in dba_users.
However, likely one half or more of the defined users no longer connect
to the database. I want to purge out the users that do not use the
database.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques
Title: RE: Invalid column in table - how to access it?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
I have a table - messages. I couldn't access one column in this table
when I do
Select name from messages;
I get an error message - ORA-00904:
Title: RE: Partitioning
I'll add that for HASH partitions or subpartitions you can only specify TABLESPACE, all other storage parameters are taken from table / partition defaults. At least in 8.1.7.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
YES,
Title: RE: SQL struggle
(see answer below)
-Original Message-
From: Saira Somani [mailto:[EMAIL PROTECTED]]
Oracle 8.1.7 on AIX 4.3
Here is what my data looks like in a table called item_w:
WHSE_CODE ITEM_NUM LAST_COST
--
Title: RE: Autoextend on Oracle 7.3.4.5.0
Actually autoextend datafiles were available in Oracle 7.3.4. I just checked in the Oracle 7 Server SQL Reference Manual (HTML) that we have here. I do remember though that you wouldn't see the autoextend column unless you applied the right patch or
Title: RE: Autoextend on Oracle 7.3.4.5.0
Whoops, my mistake. Just read what Rachel Carmichael said, she had the right answer.
-Original Message-
From: Jacques Kilchoer
Actually autoextend datafiles were available in Oracle 7.3.4.
I just checked in the Oracle 7 Server SQL
Title: RE: Null Event in v$session_wait
I was looking this up on Metalink just the other day, and here is one of the items of interest I found:
Doc ID: 408286.999
In my case I was trying to do a online index rebuild in 8.1.7 so I went with support's explanation.
NULL event shows up in
... :)
-Original Message-
From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]
Hello list members.
A colleague of mine has written a small Windows client utility that allows you to view the SQL statements being issued by another client application. The utility has to be running on the same machine
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Looks pretty nice. Real similar in concept to TOAD's SQL Monitor, but adds the option of seeing the values of bind variables, formatting the SQL, watching processes, etc.
Worth the download, IMHO.
-Original Message-
From: Jacques Kilchoer
Title: RE: Looking for simple monitor script dbup.bat
If I understand you correctly, the problem is that you don't get an ERRORLEVEL set when you are unable to connect to a database. Have you tried sqlplus/nolog? (Ignore the french text, I have Oracle installed in french on my PC)
D:\sqlplus
Title: RE: Maximum enabled roles
Huh. In the Oracle 8.1 documentation (Oracle8i Reference - Release 2 (8.1.6) - Part Number A76961-01) I see a default value for MAX_ENABLED_ROLES of 20. However in the 8.1.7 database I'm running on my PC max_enabled_roles is not mentioned in the init.ora, and
Title: RE: Help with a truncate command in a procedure
(pant pant)
Will I be the first to say that you need to use dynamic SQL?
dbms_sql package in Oracle version 8.1
execute immediate in Oracle version = 8.1
-Original Message-
From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
I am
Title: another possibility for running Oracle / UNIX at home
A few days ago someone had asked about what options are available for running Oracle (database) on UNIX at home.
I just saw this article:
http://www.macdevcenter.com/pub/a/mac/2002/11/12/oracle_part1.html
Installing Oracle 9i on Mac
Title: windows application to show sql being executed by a client program
Hello list members.
A colleague of mine has written a small Windows client utility that allows you to view the SQL statements being issued by another client application. The utility has to be running on the same machine
/intro.html?src="">
Developer's release of 9iR2 EE for MAC OS X.
Jacques Kilchoer [EMAIL PROTECTED]
A few days ago someone had asked about what options are available for
running Oracle (database) on UNIX at home.
I just saw this article:
http://www.macdevcenter.com/pub/a/m
Title: RE: How to create a new oracle database from SVRMGRL??
If I may be so bold as to add a few details
on a UNIX server you can just fire up sqlplus (or svrmgrl for older versions of Oracle) and issue the create database statement.
On a Windows server you must first create the service
Title: Oracle 9i Version Statistics
I had a colleague ask me about Oracle 9i Version Statistics. I couldn't see anything about that on Metalink, 9.2 / 9.0 new features guide, or through a Google search. Is there such a thing or did the colleague misread the name of a new feature?
Title: RE: Identifying indexes
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
I am trying to find out what indexes are in the database only
for performance
reasons and do not enforce a constraint. What would be the
query to do that?
This query will
Title: RE: SQL puzzle - using where (a, b, c) in select (a, b, c from...
-Original Message-
From: Naveen Nahata [mailto:[EMAIL PROTECTED]]
Sent: mercredi, 20. novembre 2002 03:58
Why not use some suffieintly random and crap value
lets say '~~~CRAP~~~' to replace nulls in NVL
Title: RE: SQL puzzle - using where (a, b, c) in select (a, b, c from...) an
Thank you for your answer.
Your answer would solve my problem, except for the fact that i want a general purpose solution that would work in any table. What if the three columns in the table were varchar2?
Title: RE: SQL puzzle - using where (a, b, c) in select (a, b, c from...
Thank you for your answer.
This is not an answer to the problem as stated in the original description. Your statement deleted duplicate rows in widgets_copy even if they were NOT present in widgets.
-Original
Title: SQL puzzle - using where (a, b, c) in select (a, b, c from...) and columns can be null
Maybe there is a simple solution, but I'm too tired to think of one now.
I have two tables, widgets and widgets_copy. Each table has columns that can contain null values.
SQL select id, cost,
Title: RE: SQLPROMPT
If I may add a suggestion to what Mr. Bobak had to say:
I have a connect.sql script in the same directory as the login.sql script.
The connect.sql script has the following lines:
connect 1 2 3
@@login
The reason I have 2 and 3 parameters is to be able to say
@connect
Title: RE: checkpoint not complete
-Original Message-
From: Mike Sardina [mailto:[EMAIL PROTECTED]]
I am noticing in the Alert Log that it notes quite often
Checkpoint Not
Complete. What causes this? Does something need to be tuned? What
parameter?
The message is because
Title: RE: Website that contains materials about performance tuning of S
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
For Oracle, the best resource I've found is a book (not
free, but pretty
inexpensive) Oracle SQL Tuning Pocket Reference by Mark Gurry
Title: RE: ROWID in statement trigger
-Original Message-
From: Connor McDonald [mailto:[EMAIL PROTECTED]]
have a package type as a plsql table of rowid
statement-before:
plsql_table.delete;
row-after:
plsql_table(plsql_table.count+1) := :new.rowid;
statement-after:
Title: RE: [Q] wield create view error, need help?
see answer below
-Original Message-
From: dist cash [mailto:[EMAIL PROTECTED]]
I have ORACLE 8.1.7 on SUn Server. I have wield problem on
create view. If
I only use select .., I don't have error. But if I use
createor
Title: RE: How to pass value from SQL*Plus to Unix scripts?
-Original Message-
From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]]
SQL select value from v$nls_parameters where
parameter='NLS_CHARACTERSET';
VALUE
Title: RE: But I *want* to use RBO!
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
No more RBO as of 10i...
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT_id=189702.1
Does this mean Oracle is getting rid of their data
Title: RE: SQL and case structure
-Original Message-
From: Droogendyk, Harry [mailto:[EMAIL PROTECTED]]
I've used SAS's version of SQL and it allows the coding of
conditional logic
in the SELECT statement:
proc sql;
select acct_no,
case substr(acct_no,16,1)
when '1'
Title: RE: Client not using tnsnames.ora?
Do you have several Oracle Homes on the client? If so you need to modify the tnsnames.ora in each
%ORACLE_HOME%/network/admin directory.
Do you have any tnsnames.ora files outside the %ORACLE_HOME%/network/admin directory?
If I remember right, the
Title: RE: Restrict certain database access using 3rd party tools.
Stupid DBA trick #32, or how to drive your DBA colleague wild on April Fool's day:
go over to her machine, and change the name of the SQL*Plus executable (%ORACLE_HOME%\bin\sqlplusw.exe, plus80w.exe or whatever it is) by
Title: RE: Restrict certain database access using 3rd party tools.
P.S. IIRC this will happen with any client program using SQL*Net:
e.g. change My_program.exe to (My_program).exe and SQL*Net will be unable to establish a connection.
-Original Message-
From: Jacques Kilchoer
Title: RE: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared
You might not have a public synonym for dbms_system.
Try
execute SYS.dbms_system.set_sql_trace_in_session (:sid, :serial#, true)
-Original Message-
From: Bob Metelsky [mailto:[EMAIL PROTECTED]]
All Im
Title: RE: auto start db???
Do you see anything in the alert log for that database?
Another option would be to leave the database as manual startup in the services control panel, write a DOS batch file to start it up, then place the DOS batch file in the Startup section of the Start menu.
Title: RE: Tool to load data
http://www.quest.com/requests/?RequestDefID=49
-Original Message-
From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
How do I get it for a trial?
David
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
TOAD has a GUI SQL
Title: RE: svrmgrl echo v$database in script
The shell thinks that $database is an environment variable.
Try instead select name from v\$database
-Original Message-
From: Baker, Barbara [mailto:[EMAIL PROTECTED]]
Oracle 8.0.5
Solaris 2.6
List:
I've created a script (ksh)
Title: RE: disable validate on a partitioned table?
-Original Message-
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
This is probably b/c the unique key does not include the partitioning key.
The unique key did include the partitioning key. Here is my example (Oracle 8.1.7.2.1
Title: disable validate on a partitioned table?
I read the following in the Oracle 8.1 manual:
Oracle8i SQL Reference, Release 3 (8.1.7), Part Number A85397-01
SQL Statements:
CREATE SYNONYM to DROP ROLLBACK SEGMENT, 3 of 31
DISABLE VALIDATE disables the constraint and drops the index
Title: RE: STILL HAPPENING: Metalink problems loading images?
On what kind of page do you see the error?
I can't get to gts214... either but when I go to the Metalink start page I don't see any images missing.
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
OK,
Title: RE: disable validate on a partitioned table?
-Original Message-
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
As you know for a partitioned table: unique constraints
could be enforced by a local index or global index.
For local index: the unique key will be part of the
Title: RE: Same SQL statement, Same Oracle, Different OS == Different Expla
(see answer below)
-Original Message-
From: Sam Bootsma [mailto:[EMAIL PROTECTED]]
One of our developers is encountering a situation where
Oracle 9.0.x explain
plan chooses one index when on UNIX,
Title: RE: Export question on excluding certain schema
Also, by default, in Oracle 8.1.6 MDSYS and CTXSYS are already excluded from the export, so no editing of catexp.sql is needed to do what the original poster wanted to do.
# grep MDSYS $ORACLE_HOME/rdbms/admin/catexp.sql
u$.name not in
Title: RE: connect to the databases without using tnsnames.ora?
-Original Message-
From: CC Harvest [mailto:[EMAIL PROTECTED]]
Does anyone here knows how to setup the connections to
the database server without using tnsnames.ora?
Our DBA didn't use it. But I don't know how
Title: RE: Coercion issue
It's because of the order that the conditions are checked in the joining of two comparisons with AND.
Example:
-Original Message-
From: John Weatherman [mailto:[EMAIL PROTECTED]]
Sent: mercredi, 4. septembre 2002 09:44
To: Multiple recipients of list
Title: RE: Coercion issue
It's because of the order in which conditions are evaluated in two expressions joined with AND.
Example:
SQL select v from t ;
V
--
A
1
AA
11
SQL select v from t where to_number (v) 0 and v like '1%' ;
V
--
1
11
SQL select v from t where v
Title: RE: Trace file with tkprof
-Original Message-
From: Chuan Zhang [mailto:[EMAIL PROTECTED]]
Is there any way to get the same execution statistics between
the finished sql statement and interrupted sql statement?
Supposed table A have ten million rows.
If select
Title: RE: PCTUSED - when is block added to freelist?
The way I understand it:
If you have a low pctused, then you have less blocks being moved to the freelist (because it's less probably that a block will be moved to the freelist): so reduced processing costs during update (if a row length
Title: RE: Table Locks
-Original Message-
From: Alan Davey [mailto:[EMAIL PROTECTED]]
Jacques, v$locked_object shows the table, but I already knew
which table was locked. I was hoping to find the offending
SQL statement.
Sorry, I misunderstood. I thought you were trying to
Title: RE: PL/SQL Editor
I hate to seem like I don't have a sense of humour, but wouldn't a more ethical way be to pay for the full version of the product?
-Original Message-
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
You said One note about the Freeware version of
Title: RE: Table Locks
Does v$locked_object show anything for those tables?
-Original Message-
From: Alan Davey [mailto:[EMAIL PROTECTED]]
I've noticed some locks on various tables and I'm trying to
figure out which DML statements are causing the locks. In
this example, the
Title: RE: To_Char Problem
a) Do not convert date fields to characters in a comparison. In your query, use
and a.updated_date = (select max(updated_date) ...
b) If you absolutely want to create two character strings from a date, and then compare the strings, this is the format to use:
Title: RE: DBA tools on NT - PERL
-Original Message-
From: Pat Hildebrand [mailto:[EMAIL PROTECTED]]
I'm not responding to any single message here but a few general
comments about perl.
All right already! I'll quit using C/gcc and start using Perl!
Is this the first book I
Title: RE: Nologging and redo generation
-Original Message-
From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
Can I use the nologging option on simple inert and deletes to
eliminate
rollback problems and redo generation?
Which version of Oracle?
From Oracle8i Concepts
Release 2
Title: RE: pl/sql exception and whenever sqlerror
(see answer below - What a difference, a raise makes!)
-Original Message-
From: Baker, Barbara [mailto:[EMAIL PROTECTED]]
I have a command procedure running a sql*plus script that
then runs a stored
procedure. (This is VMS,
Title: RE: Simple question on logging..
-Original Message-
From: Peter R [mailto:[EMAIL PROTECTED]]
How can I turn off logging for a table in Oracle7.3 database.
Recoverable/unrecoverable is not a persistent attribute in 7.3.4 The unrecoverable option only applies to the
Title: RE: RE: Dba tools on NT
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
How many of those non-cryptic languages can dump a table
to a CSV file in 2 lines of (readable ) code?
while ( my $ary = $sth-fetchrow_arrayref ) {
print q{} .
Title: RE: Apple rack-mounted servers
From my Mac OS X Advanced Quickpro guide: it's a combination of the Mach kernel and FreeBSD.
-Original Message-
From: [EMAIL PROTECTED]
mach kernel, IIRC. The old NeXTStep unix.
-Original Message-
From: Grabowy, Chris
Title: RE: c_USER#
-Original Message-
From: BigP [mailto:[EMAIL PROTECTED]]
I am finding SYS.C_USER# as one of the hot blocks .
I dont find any documentation about it , can somebody shed
some light on it . why it is contention ?
SYS.C_USER# is the name of the cluster that
Title: RE: Dba tools on NT
-Original Message-
[EMAIL PROTECTED]
Scripting: Perl, because it can do anything you ask of it.
Editor: Vim - www.vim.org - same reason
Actually I like this little text editor:
http://www.fixedsys.com/context/
One of its advantages is its syntax
-
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
If the cluster contains also the current disk usage as part of table TSQ$ then this means that Oracle has to keep updating the cluster everytime a user adds or releases disk space, right?
-Original Message-
From: Jacques Kilchoer [mailto
Title: RE: Dba tools on NT
Mr. Gupta is very wise. The Quest set of tools is the best.
-Original Message-
From: Manavendra Gupta [mailto:[EMAIL PROTECTED]]
Quest software (www.quest.com) provides a nice array of tools.
Title: RE: Dba tools on NT
But... but... in my defense, can I point to the subject line of the request? on NT
-Original Message-
From: Ron Thomas [mailto:[EMAIL PROTECTED]]
Actually I like this little text editor:
http://www.fixedsys.com/context/
One of its advantages is its
Title: RE: It took more than an hour to update 10,000 records
Actually, since the statement that is slow is an update, I would suggest also sending the execution plan to the list for suggestions.
In SQL*Plus:
a) if necessary, create the plan_table using $ORACLE_HOME/rdbms/admin/utlxplan.sql
Title: RE: DUAL revisited
-Original Message-
From: Kathy Duret [mailto:[EMAIL PROTECTED]]
But I don't get this error when I query from dual just from
the new v$dual.
That's because your v$dual view is assessing a SYS.X$ table. To do an explain plan on a SYS.X$ table you have
Title: RE: Live Webcast: The death of the buffer cache hit ratio
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Ok, everybody, let's show up in support of Anjo.
This should be a great presentation.
Sorry if someone has already posted this to the list
Title: RE: Display all privilleges belong to user
-Original Message-
From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
How do I display all privilleges belong to an user?
Here is a sample script. It will show all privileges granted to a user and all privileges to the roles
Title: RE: Ids and passwords for application users
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
I think the real issue is who is going to keep the usernames
and passwords
maintained. Is it you? Do you have that much spare time?
At my previous employer,
Title: RE: data modeling question - child table with multiple parents
From: Igor Neyman [mailto:[EMAIL PROTECTED]]
here is an argument against this solution:
in current economy, some day you'll have a lay-off, and you'd want to
delete an employee (you will be laying off employees -
Title: RE: Creating sequences on the DUAL table?
answer below
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
I have a request from one of our developers to create two new
sequences on
the DUAL table.
This seems like a bad idea to me. I've never had
Title: RE: user(s) RBS
-Original Message-
From: Charlie Mengler [mailto:[EMAIL PROTECTED]]
If I'm interested in a specific RBS, how do I determine which user(s)
are making use of this segement?
How do I determine which RBS a particular user is using?
You could try this
Title: RE: ORA-1658 even though there is enough contig free
Could it be because of the minimum extent size? Though I would think it unlikely that your minimum extent size would be greater than 147MB.
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
On 8.1.7.2.0 on
Title: RE: Ids and passwords for application users
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
If a common login is used (which is the case with most
applications),
dbms_application_info can be used to set the actual username
in either the
module
Title: RE: naming conventions for Oracle/Unix vs. SQL Server
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Please help. I work in an organization where we have both
SQL Server on NT and Oracle on Unix. SQL Server and
developers who are used to GUI's in NT
Title: RE: Slightly OT: Chart generation tool for db monitoring scripts
Couldn't you do this with, for example, Microsoft Excel? I mention Excel because it's very common, but any spreadsheet program like Lotus 123 could probably do it also.
-Original Message-
Sent: Monday, July
Title: RE: Install Oracle 8i on Windows XP?
Mr. Pierce - the only ad hominem attacks I saw were from you. Someone posted Don't use Windows, a generic disparagement of the operating system. You immediately responded with a personal insult calling the person an asshole.
You then followed it up
Title: RE: Ids and passwords for application users
I always preferred the option of having a userid for each person, because it makes it easier to match session to user. When you say userid dwilliams locking a table you know who to call, but if you see userid app_user you have to do some
Title: security policy aka fine-grained access control (was: lock against inserts)
I see that Mr. Buchan answered his own question (use dbms_lock inside an insert trigger to wait until the processing is done.) But after reading your question I looked at security policies aka fine-grained
Title: RE: Errors trying to connect from 8.1.7 client to 7.3.2 server
What does the tnsnames.ora entry on the client machines look like? In the CONNECT_DATA entry, do you have SID=
(connect_data = (sid = AAA))
or service_name = and instance_name = ?
(connect_data = (service_name =
Title: RE: Export syntax
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: lundi, 22. juillet 2002 23:53
To: Multiple recipients of list ORACLE-L
Subject: Export syntax
the following syntax gives invalid col name :
exp test/test file=expt.dmp
Title: shutdown abort / startup restrict / shutdown vs. shutdown immediate
-Original Message-
From: April Wells [mailto:[EMAIL PROTECTED]]
The solutions (the ones that I got) aren't good ones.
Shutdown abort/startup restricted/ shutdown immediate... (a 'VALID
solution'???)
Title: RE: Custom Reports from Aspect System
Could you try to connect internal on the server and create another user with DBA privileges?
-Original Message-
From: Rodd Holman [mailto:[EMAIL PROTECTED]]
Are any of you using an Aspect phone system. This system
maintains a small
Title: RE: HOW TO MAKE FAST EXPORT
You're right (someone else had made the same comment.) I missed the word reorganising in the original e-mail. My apologies.
-Original Message-
From: Joan Hsieh [mailto:[EMAIL PROTECTED]]
I used transportable tablespace to do this. It is fast,
Title: another security issue with Oracle 9.x
I hate to seem overly alarmist, but in addition to the SNMP security issue mentioned already, I have read of this problem discovered by Next Generation Security Software Ltd. in Sutton, England:
Title: RE: PLEASE HELP WITH STATEMENT.
If primus_temp_dump is an Oracle table name, then you would just say
dbms_sql.parse (cursor_id, 'TRUNCATE TABLE PRIMUS_TEMP_DUMP', dbms_sql.native) ;
If primus_temp_dump is a PL/SQL variable, you would want to declare it in your procedure, and then
201 - 300 of 534 matches
Mail list logo