 | | | Oracle List | |
I 've had this sometimes when our backup software touched the file and for a split second and blocked it. I 've also had this happen when someone truncated the file incorrectly to clear it usually byOn 2/15/06 Chris Stephens <cstephens16@(protected) > wrote
>
> submitting the file and storing it as a clob went fairly quickly.
> parsing the xml document into relational tables was taking about 1
>
>I currently have a 9.2.0.7 and two 10.2.0.1 databases that are set to an AL32UTF8 character set. Some of the data that is being inserted into these databases appear as ????. Is anyone else having th
There are various post-import tasks that belong
to certain schema. OUTLN has one and one
of its jobs is to delete outlines that are not self-
consistent. It certainly used to be the case in 8i
thLarry
So add another IF statement in your monitoring script to not page you
between 23 45 and 1 15.
Problem solved.
Dennis Williams
On 2/10/06 Wolfson Larry - lwolfs <lawrence.wolfson@(protected)I am looking at setting up a function based index. From the docs it
states must set query_rewrite_enabled to true in order to use the index.
I had thought that setting this parameter was not requireHey all.
Does anybody know whether the number of parallel slaves assigned to a session count toward the user 's SESSIONS_PER_USER profile limit? For example if a user submits a query with degree ofHi
I tried using data pump for the first time today and am getting the
following error (Solaris 5.9 and Oracle 10.2.0.1)...
gsun863-enid1 $ impdp system DUMPFILE pcv.dmp DIRECTORY pcv_export
SCHEThe statspack report shows "high Avg read time " (more than 10000 ms)
for Temp tablespace. This is true only when particular batch job runs.
The batch job is not doing any ORDER BY DISTINCT UNION and And the morons you work for want detailed installation instructions
written up for documentation purposes.
Doesn 't help that Oracle changes the rules with every release.
Very bottom of this page
http //education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_i
d 47
Looks like it 's out there.....
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQuest InfoHi
I have a standby database 10.2 non-managed. I want to know what was
the last timestamp of the transaction that is applied to the standby
database. I can get the maximum sequence# and last SCN apHmmm... We might need more information.
Files that "were produced on NT " "appear to be
endless on Linux ". How precisely is Linux
"seeing " these files? Have you copied the files
to a local (Linux
Yes . the file pass ok with the same size.
Hi I wonder if any succeed to copy tablespace from window (32bit ) to
sun (64bit)
We are tring to use streams (which is very cool ).
The command we use is
BEGIN
DBMS_STREAMS_TABLESPACEI 'm used to the old (8i) way of handling rollback. Oracle seems to be
pushing automatic undo management (AUM) so I get an undo tablespace
when I create a 10g starter database to dump my import into.
I 'm trying to come up with some sizing figures to help predict future
space needs. Unfortunately I 've found that I get inconsistent results
across DBA_DATA_FILES DBA_FREE_SPACE DBA_SEGMENTS and D
Hi Guys
Could any body suggest workaround to import data from database charset
WE8ISO8859P1 to database charset UTF8 Here it is my error!
import server uses UTF8 character set (possible c > With 10g you get easy connect.
>
> e.g. sqlplus scott/tiger@//someserver 1529/orcl
And in 8i/9i you can connect with
sqlplus
username/password@ '(description (address (protocol <protocol >)(host <Krishnan this is how the to_char function works it always leaves one
extra leading space in the output to accommodate a potential minus sign
when the format mask consists only of "9 "s (and potentiaWhat is the error? What is a_ATWRT?
--
Ron Reidy
Lead DBA
Array BioPharma Inc.
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of RoNothing wrong with ODBC when used right. How did a query using this
level of resources go unnoticed for over a week?
On 2/9/06 Norman Dunbar <norman.dunbar@(protected) > wrote
>
> Morn10.1.0.2 Linux RH3 update 6.
Ok this used to work now all of the sudden I get
If I do export I get
EXP-00008 ORACLE error 3113 encountered
ORA-03113 end-of-file on communication channel
EXP-000 Raptor messes all my comments in cyrilic in any source object. It cannot
dabug also. So far - so bad )
For an early beta it seems quite useful.
Yqvor
--
http //www.freelists.org/webpage/oracle-I have a log table that is logging various PLSQL calls. Assume the
table looks like this...
PROCEDURE_ID
hi all
We have a case with oracle 8174 running on solaris after we did a bounce
increased process from 9k to 10k and some shared pool size increase.
statspack snapshot begin to core dump and wOn a related note have you guys noticed the very large memories on a
"round " address with KSMCHCOM 'permanent memor ' and KSMCHCLS
'perm ' ?
SQL > select * from sys.x_$ksmsp where KSMCHCOM 'permaDear all
In OEM 9i I used to be able to define reports using
SQL which produced HTML output (using bold / colors
etc. to emphasise important values etc.) however in
10gR2 Grid Control my HTML oualso if the underlying object(s) have a nonzero parallel degree the rule hint can be ignored...
|
|
|
