 | | | Oracle List | |
RE
On 8/9/07 Jay.Miller@(protected) <Jay.Miller@(protected) > wrote
>
> Before I write one does anyone have a script handy (or know of one
> online) that will generate the DDL for a view thaSounds like you 'll want to upgrade to 11g ASAP and make use of the new
Flashback Data Archive
http //www.oracle.com/technology/products/database/oracle11g/pdf/flashba
ck-data-archive-whitepaper.pdf
Here is the process that we followed.
1. Connect as the SYSMAN user in grid control.
2. Configure the SYSMAN user for all email notification.
3. Create a user called PAGING_USER that has the pagiAdd the use of services to this with the resource manager you can then
tune usage by service allowing a service to only have so much resource
between certain times.
Your SQL users then use a differeHi
Is there any way..............!!!!!!!
is there any way to be able to give priority to the application (which runs under user APPS) as compared to normal users executing SQL statements undHi
O/S is HP-UX
1)select * from nls_database_parameters
NLS_LENGTH_SEMANTICS CHAR
2)select * from V$nls_parameters
NLS_LENGTH_SEMANTICS BYTE
3)In init.ora it is
Only thing I know of is the last ddl time of a table and you could probably
find some things using logminer although I have no personal experience yet.
But from what I have seen (mainly in this list)List
This is Oracle 8i.
I need to write a script to ensure a user has access to all the tables
views etc. that are needed. So I assumed that I just needed to query
ALL_TABLES as the user. Did thHi
I should guess it meands Database Vault
/johan
On 8/8/07 Louis BROUILLETTE <Louis.Brouillette@(protected) > wrote
> I just began looking at CPU July 2007 documentation. In table 6
> (Patch availab <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN " >
<html >
<head >
<meta content "text/html charset ISO-8859-1 " http-equiv "Content-Type " >
<title > </title >
</head >
<body bgcolor "#ffffffHi Robert
You should just tell us your rss address ONCE so I think everyone can get
your update.
On 8/8/07 Robert Freeman <robertgfreeman@(protected) > wrote
>
> I 've posted another Blog entry wiWhy not
select * from view
order by col
Instead of putting the order by in the view definition?
And don 't you have to alias the count(cust_no) expression?
Ron Reidy
Lead DBA
____________On 8/8/07 Mathias Zarick <Mathias.Zarick@(protected) > wrote
>
> there are even recommendationsto to revoke this if you have critical
> security requirements.
>
Considering that a savvy user that pga_aggregate_target matters see example below (for the original
example thanks to Christian Antognini)
SQL > create table source as select * from dba_source
Table created.
SQL > insert into source Daniel
Not sure what platform or version of Oracle you 're on but I did run into
something similar on AIX with Oracle v9.2.0.5. An overview is in
MetalinkNote #3639594.8. It 's a bug. Check the nG 'day All.
I 've been trawling the oracle doco for info on how to set up a JMS
provider in Oracle App Server. The App server side of it seems OK now
but it requires AQ in the database. This is wherAny one on the list used Sentrigo hedgehog
http //www.sentrigo.com/
NI light of the fidelity incident our compnay is evaluating solutions for real time monitoring and i was wondering if anyone has Also it 's not called MTS anymore it 's shared server.
RF
Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints
Father of Fi
Folks
Data from a NON-RAC Database existing in version 10.2.0.2 needs to be moved to an ASM-RAC Database on the Same Machine. ORACLE_HOME of ASM RAC setup is 10.2.0.3
NOTE - NON-RAC Database existsThe cache he is talking about is in the array and hence is not available to
the SGA. I fear that you are in for some iteration. The amount of usable
cache memory depends on the unique I/O signature On 8/3/07 Li Li <litanli@(protected) > wrote
>
> Hi all
>
> I wonder if anybody on this list has PeopleSoft ERP DEV/TEST environment
> (including database app/web server process scheduler etc) runwe have ORACLE 10gr2 on Redhar AS 4.3. ORACLE version
is 10.2.0.2.
Today we have users report can NOT connect to
database. I checj listener and found there have two
listeners (parent and child). THello All
I am working on a project to create a reporting environment from an Oracle
E-Business suite database that will be at 10.1.0.5 by the time the reporting
project takes off. The source databLooks like an obvious fake to me - see here for more info
http //mail.google.com/support/bin/answer.py?hl en&answer 8253
"Gmail doesn 't send unsolicited mass messages asking for passwords or
persDoes anybody know how to unwrap packages in 10g?
I have seen Pete Finnigain 's article for 9i.
thanks.
>Has anybody been able to get the code for this procedure?
>
>If not what *.plb file installs On 8/3/07 Don Seiler <don@(protected) > wrote
>
> The alert log will have a number of messages like this
> Fri Aug 3 08 50 09 2007
> Errors in file /u00/app/oracle/admin/dev2/bdump/dev2_j001_2045.trcIs this RAC or standalone? What flavor of UNIX? Anything in the alert log?
On 8/3/07 jurgen_mortier@(protected) <jurgen_mortier@(protected) > wrote
>
>
> Hi
>
> I have a production DB that has been res
Restoring a ControlFile requires a RECOVER .. FROM BACKUP CONTROLFILE
and consequently an INCOMPLETE RECOVERY.
You would do so only when
a. You do not have the current controlfile
b. You are clOracle 11g anyone??
http //robertgfreeman.blogspot.com/
RF
Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints
Father of |
|
|
