 | | | Oracle List | | Ciao Simone
you can update the column values using Pl/SQL code not a SQL command
here is an example very close to your requirements
create or replace trigger NtfRcpt_lastUpdate
before insertHi all
It is not advisable to take RMAN backups through the network on
Windows. However this is the solution we have to deal with for one of
our customers.
All backups take about 10 times longer thaThe manual is quite good on that and include a step by step
Here are my notes for a logical you will just have to replace the word 'logical ' by physical '
ie ) alter database create physicalIn light of Jared 's highly informative presention on why we should normalize
for performance (Hotsos 2006) I was struck by this statement.
http //www.quest-pipelines.com/newsletter-v7/newsletter_0406RTFM
/etc/oratab
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Hello
I usually do
echo user/pass@(protected) > .file
sqlplus $( <.file) @(protected)
imp $( <.file) control .....
HTH
Enrique
On 5/4/06 Wolfson Larry - lwolfs <lawrence.wolfson@(protected) > wrote
>
Recently in this list there was a proposal to group sql statements by
execution plan. Chances are that they are actually the same! Not a 10g
feature though or not a feature at all.
2006/5/4 ryan_g > The function of AWR is same as STATSPACK. Is it possible to migrate
> STATSPACK data to the AWR?
Here 's some kind of Oracle 's answer
There is no supported path to migrate Statspack data into AWR. This is not an urgent situation as this only involves a test instance of the
database. Here is the situation. I refresh our TEST and DVLP instances of
our production database through a series of scrTanel P?der has an interesting presentation on this
http //integrid.info/hotsos05/Advanced%20Research%20Techniques.pdf
HTH
Stefan
On 5/4/06 Schultz Charles <sac@(protected) > wrote
>
> AnyoneThanks St?phane David Paul Ghassan
This was what I assumed but I thought I would see if I was overlooking
anything.
Dennis Williams
On 5/3/06 Stephane Faroult <sfaroult@(protected) > wrote
>Interesting as none of those bug numbers appear on MetaLink.
(Advanced search bug id)
Can you provide more detail as to what these bugs involve?
I 've run into a couple issues on 10.2.0.1 that are hi list
i have one question i have refresh my development from production. the
problem is as
1) there could be more tables in production than in development but i have
to consider only those tabldear all
even when processing item_product2 has cost more than 1000 but then the final cost become very small (final cost 16) and very significant?
according to execution time same as which final cDennis
With partitions Oracle switches to CBO whatever OPTIMIZER_MODE
says (a good symptom of that is the appearance of cost estimates in
execution plans). Therefore the best you can do is Paul
Your question is one of laws and licenses not technology.
Only with "hardware partitioning " a feature that generally appears in
only very high-end (and high-price) servers are you ablList
Does anyone have any experience running OPTIMIZER_MODE RULE with some
tables partitioned in Oracle9i?
I have an application on Oracle 8.1.7.4. The vendor specifies
OPTIMIZER_MODE RULE. ThHey all.
Does anybody know an easy way to provide read privilege for all users on
trace files generated by SQL trace? Environment is Oracle 10g on Sun
Solaris. I know that we can write a cron job Oracle keeps many users waiting on April patches
Thorough and cautious or 'slow and lazy? '
http //www.computerworld.com/securitytopics/security/holes/story/0 10801 111098 00.html
"Oracle users can fi
Try also http //sdn.sap.com (registration is free) --and--
http //help.sap.com/saphelp_nw2004s/helpdata/en/5e/0f123b8d07db53e100000
00a11402f/frameset.htm
http //help.sap.com/saphelp_nw2004s/helMuqthar
>What if the database size is small and stored on a single or 2-disk on a system.
>The master key has to be stored on one of the disks. What if both disks are
>stolen........is your databaI have a question about Oracle internal processing of commit.
Here is excerpt from Oracle wits evenst description
log file sync
When a user session commits the session 's redo information needs toLaura
Sorry I 'm a little late on this but do any of the tables have
"NOLOGGING " set? This will cause DML to be unavailable within the
archive logs.
Dave
Pythian group has recently taken over the maintenance of DBD Oracle
the principal means of connecting to Oracle from Perl. This driver has
some weak points and shortcomings which are severely restriHere is the scenario
HP UX 10G R1 DW noarchivelog cold backup only
Attempt partial clone to recover data from one tablespace
Tablespace X contains datafiles 1-6
Tablespace X was put in readonlyHas anyone made good use of the oracle workspaces? Used it to function as
multiple dev environments and save space?
Brian S.
dba1 mcc wrote
> 1. recreate "role "?
>
> 2. recreate "grant role " script?
You have not said what version.
Anyway in 9.2.0.6
Use select dbms_metadata.get_ddl( 'ROLE ' 'role name ') from dual
to geDamn!
Going thru that list will take longer than learning how to do it
yourself!
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of MLarry
Are you running multiple listener processes on the same machine?
Use the "set current_listener " command to change the name of the
listener log. Something like
LOG "listener.`date '+%m%b%e%a |
|
|
