 | | | Oracle List | | Kanwar
Based on the limited information you provided here is another possible
route for you to consider depending on your situation and your success with
the method that Pat has described
If you Bala
You can try
Update table
Set column_name substr(column_name 1 instr(column_name ' ' 1)-1) ||
'9999999999 ')
Where {anything}
Tom
1. Look at your caching rules.
2.
http //download-west.oracle.com/docs/cd/B14099_01/caching.1012/b14046/to
c.htm (for 10.1.2 but maybe still applicable)
3. http //httpd.apache.org/docs/2.0/misc/perOf course you can export sys
oracle@(protected) /u00/app/ucc/ [ORA9206] exp owner sys file sys.dmp
Export Release 9.2.0.6.0 - Production on Fri Jun 29 09 46 16 2007
Copyright (c) 1982 2002 Oracle CorHi Gurus
Have a simple doubt. I did an experiment to know which DML statement
generates the Most/Least amount of UNDO for the same no. of records.
Steps
After several hours of reading blogs metalink notes corresponding with
some of you and trying to get the Oracle Support analyst to understand our
predicament we took a leap of faith and tried out mHi
I 've been trying to transport a tablespace via rman.
rman does that through an auxiliary database.
So if i understand the process correctly this happens
rman uses the sourcedb to get the data
Hi Neil
on my Unix server the 9i oracle binary file (named oracle) contains
the string "Oracle9i Enterprise Edition Release %d.%d.%d.%d.%d - 64bit
Production " whereas the standard has "Oracle9i ReEvening all
Running clustersetup.exe on a two node Windows 2003 64 BIT cluster with the
Oracle 32 binaries.
I ran clustercheck successfully and am using the patched version (4374610)
of clutersetup.Did you set the persmissions of disk to oracle user on Node 2 when the node
boots up??
Are they still under root user on the second node?
On 6/27/07 Charles Schultz <sacrophyte@(protected) > wrote
>
I did an export from Oracle 9.2.0.7.0. with the imp utility on the Oracle 9 server.
Then I tried to import the dump files into 10.2.0.1.0 with the imp utility Oracle 10 server.
The import worked forHi
If I am installing Oracle 10g Enterprise edition and uncheck the Oracle Partitioning option [ Means nO Partitioning] does that mean that AWR will not work or will not utilize partitioning. I
Hello gurus
We are planning upgrade from 10.1.0.4 to 10.2.0.3 of HP-UX PA-RISC based system. Everything is on raw devices (no CFS or ASM). We can afford downtime (starting Friday evening).
I am Below is a script written several years ago to copy users from one instance
to another.. After using these scripts you can uese exp/imp to copy
tables. Obviously in 10g you can use datapump for thiPatty
What version of AIX are you on? As you 're probably aware db_block_buffers
is deprecated in favor of db_cache_size. If you 're using Automatic Memory
Management you need to look at a coupleYou may use Oracle Enterprise Manager and use option 'create As ' which will
give you complete sql to do that. You can also create it within Enterprise
Manager as well.
A quite handy option.
RegarHi all
I am facing the below error when running the script. The script
actually doing the selects the table( from remote DB) and inserts and
updates to that table. Meanwhile it is throwing "ORA - 02Startup Force IS actually recommended. Check out the 9i RMan demo file
case1.rcv in $ORACLE_HOME/rdbms/demo. Also in your 10g docs check out
Backup and Recovery Advanced User 's Guide
...6 MakinHi friends
I am working on one of the RAC monitoring option. Anybody can suggest as what is good option for Monitoring RAC components with Graphical interface as well as Drill down for any issueI am reading Tom Kyte 's book and on page 444 he deals with clustering
factor. I have a partitioned table with a global index. Does anybody have
information on how the clustering factor influences We do hot backups with EMC BCV 's. All is working well but we sometimes
have a problem with a large job being run while we are in hot backup
mode. This causes the BCV split to take longer and a larGreetings
OS- AIX 5.2.0.0
Oracle
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
PL/SQL Release 9.2.0.5.0 - Production
CORE 9.2.0.6.0 Production
TNS for IBM/AIX RISC SysOn 6/26/07 Robert Freeman <robertgfreeman@(protected) > wrote
>
> Oh RATE is SOOOO 9i!! -)
>
> This is a 10g database so be looking at the *duration* parameter instead!!
> Talk all about this in chaSyed
Find your latest backup and restore the database. If the SYS objects
are gone (like TAB$) then you are screwed. You have no other way to
recover from this.
Second take all SYS privs awSorry I see now that compiling is not the issue you must be getting the
issue when you run it. I suspect your not getting a numeric someplace or you
are getting a null. I would add some debug to seeOn 6/25/07 Pedro Espinoza <raindoctor@(protected) > wrote
>
> Does oracle clusterware remotely power reset? If I recall correctly
> from what I have read from Kevin Closson 's blog it is not so.
> HoweI have implemented a debug API which appears to work quite well. One nice
feature is that it will dump wait event info roughly every 30 seconds.
However the feature could be considered "passive " in thOn 6/25/07 Robert Freeman <robertgfreeman@(protected) > wrote
>
>
> You don 't say how often your logs are switching.
>
>
Or the % of time the waits are.
--
Jared Still
Certifiable Oracle DBA and Part <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN " >
<html >
<head >
<meta content "text/html charset ISO-8859-1 " http-equiv "Content-Type " >
</head >
<body bgcolor "#ffffff " text "#000000 " >
|
|
|
