At parties we try and limit work related topics to things like
That person is such an a**! You get the idea, not to
technical.
My climbing buddies are my coworkers at well and its a rule that
we all pretty much like. For example, going snowboarding today
and I bet the only work related
Man, that is fairly easy to fix. I would make it a priority.
Unless you like the torture that is.
-Original Message-
Sent: Friday, December 07, 2001 8:45 PM
To: Multiple recipients of list ORACLE-L
Uhm..Mike, you mean you've come across the *references* to it in prints/chat
often,
and
Hi lists,
Is there a parallel import into table / schema . ?
(The table/tables have primary keys as well as indexes )
(need to finish the import in less time, than traditional import )
Thnx in advance
srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
SNOWBOARDING?
Today I'm heading to the beach to soak up some warm SoCal sun
since we are having a mild Santa Ana now!
Kimberly Smith wrote:
At parties we try and limit work related topics to things like
That person is such an a**! You get the idea, not to
technical.
My climbing
Dear Gurus , I have a problem.
I have 2 databases on an win2000 machine and want
to create the third .
When I try to create a database with Database Conf.
Assistant , it creates the service and before creating datafiles it gives
error ORA-12545 and does not create datafiles although I ignore
Sorry no Parrellel Imports nly Parrlel Exports ...
Thinking Logically this is no possible.
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 7456019
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 08, 2001
Tatireddy, Shrinivas (MED, Keane) wrote:
Hi lists,
Is there a parallel import into table / schema . ?
no.
(The table/tables have primary keys as well as indexes )
(need to finish the import in less time, than traditional import )
Thnx in advance
srinivas
you did not specify a
You can just ALTER SYSTEM SET FIXED_DATE = 'DD-MON-YY'; without setting
in ini.ora. Later set it to none will bring it back to os time.
Joan
Hallas John wrote:
Or use the init.ora parameter FIXED_DATE to set the database time
only.
John
-Original Message-
From: kranti
David,
It sounds like you had a corruption in memory. I'd
run some thorough diagnostics on the server.
The error was reported because Oracle was requesting
relative dba 0x0a877fd8. The block it received,
however, contained rdba 0x0b801ea2
Oracle records the rdba in the block itself so it can
On Friday 07 December 2001 20:35, Robert Chin wrote:
My short take on this is that a datawarehouse is a OLTP database..
What ??? I think you should keep that short take to yourself for the
benefit of those who are seeking to learn/understand about DWH.
It's not uncommon to find OLTP
Hello,
a little problem during installing Oracle 8.1.7 on Linux.
I was installing 817 and I didn't let the installer create database.
So, I'd let dbassist create scripts and I'm trying run it.
When I start svrmgrl, I get ORA-12545: TNS:name lookup failureĀ error
= I cannot connect internal to
Sorry, sorry, sorry.
Our admin didn't run root.sh during install process.
Everything goes well. :-)
Thanks.
JP
On Sat 8. December 2001 20:25, you wrote:
Hello,
a little problem during installing Oracle 8.1.7 on Linux.
I was installing 817 and I didn't let the installer create database.
I have a session that seems to be hung on a sql_statment.
Here is it's session_wait entry:
SID SEQ#
-- --
EVENT
P1TEXT P1
Try:
select ln.name from v$session_wait sw, v$latchname ln where sw.p2 =
ln.latch#.
Best,
George
www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN
Smarter than adding another team member, Pythian has new services for
supplementing DBAs: get our help with monitoring, 24x7 on-call, daily
oops, probably only want the events that are latch frees:
select ln.name from v$session_wait sw, v$latchname ln where sw.p2 = ln.latch# and sw.event = 'latch free';
On Saturday, December 8, 2001, at 04:50 PM, George Schlossnagle wrote:
Try:
select ln.name from v$session_wait sw, v$latchname ln
Ok.. it's a sort segment latch.. any way to find out why? It's been sitting
around for over an hour ...
On Sat, 08 Dec 2001 14:35:18 -0800, you wrote:
oops, probably only want the events that are latch frees:
select ln.name from v$session_wait sw, v$latchname ln where sw.p2 =
ln.latch# and
HI lists,
Can anybody tell me how to generate the sql s from archive log?
what query do I user?
Thnx in adv.
Srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Hi
root.sh will update the env files (located under
/usr/local/bin). I think it is a good idea to take them backup before
applying root.sh (Solaris 2.7)
Earlier in one installation, we got this same situation. We were to
restore them from a different server that has the same environment
Hi Paul
thnq for responding.
It is oracle 8.1.7 on solaris box (2.7)
The database is small ( 16 Gig), and used for majorly querying. No
massive inserts/updates for these databases.
The table was exported without parallel degree clause. THe whole data is
in a single dmp file. It is a 700M file
Try Using the DBMS_LOGMNR Pkg .
That is how u can get what is there in the redo Log files.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 7456019
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 09, 2001
Hi All,
I am trying to install oracle 8.1.7 on W2k Server.
OUI doesn't start at all. What could be wrong? Any-body had
any similar experience?
TIA,
Rajesh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: RAJESH DAYAL
INET: [EMAIL PROTECTED]
Fat City
21 matches
Mail list logo