Hi,
Is this characteristic of a bug or is the Oracle Architecture ?
SQL desc dba_audit_exists
ERROR:
ORA-24372: invalid object for describe
SQL select count(*) from dba_audit_exists;
COUNT(*)
--
0
SQL desc dba_audit_exists
Name Null?
Hi
I am using OAS 4082 on Sun Solaris, with Oracle 8.1.6.
I was wondering if there is any way of Using 2 DAD's (Data Access
Descriptors) with one plsql cartridge agent ?
Regards
Saj
--
Sajid Iqbal
Database Team Leader
Email: [EMAIL PROTECTED]
Website: http://www.vianetworks.co.uk
Hi,
How can I audit a table whether is selected as
SELECT col1, col2
FROM tab
WHERE col1 = 'condition';
and NOT all the SELECT queries
I'm using Oracle 8i
Thanks
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
What's about PORT 2481 for GIOP, I think you also have to use different
ports for GIOP (2481 für LISTENER817 and 2482 for LISTENER816).
regards
Volker Schoen
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de
-Ursprüngliche Nachricht-
Von: Janet Linsy [mailto:[EMAIL PROTECTED]]
Many thanks to all who replied !
Have a nice day !
DBAndrey
* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Thu, April 04, 2002 9:37 PM
To: Multiple recipients of list ORACLE-L
ex
Have you considered just adding another exception handler:
i := 1;
Hallo,
I have some trouble with this pl/sql procedure. I would like
that this lvsql to be run only if the field Borttags_flagg = 0 but i get an error in
the if statement, whatis wrong with this? It get the erromressage:
LS-00103: Encountered the symbol ||AvdNr|| when expecting one of the
How can I calculate the appropriate stocakge capacity space for a
block (8K).
It is exact to use data BLOCk_SIZE*(PCTUSED/100).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrey Bronfin
INET: [EMAIL
We had a visit today from oracle support.
The guy took a look on our NT plaything for testing
oracle 9i and said:
How come you have only 512MB memory on this?
Your database and OEM console alone use all this ram.
UPGRADE
Yechiel Adar, Mehish
- Original Message -
To:
Hi folks,
we've never identified any requirement here for using any kind of
replication. Consequently I know nothing whatsoever about Oracle
Replication. Now I've been asked whether or not we use Oracle Replication
and, if so, whether it can be disabled. So can anyone tell me whether
Replication
Deart gurus !
I'm just wondering what happens in this situation :
i issue the following SQL :
update AAA set BBB=0 where ROWID='X' ;
Now , if the value of the BBB column is already 0 for the given row (or a
set of rows) , what will actually happen behind the curtains ?
I mean, will Oracle
You don't say which version you are using but some versions of 8 had a
problem with
desc and synonyms. Try desc sys.dba_audit_trail and see if that works.
I know this
was a problem in early 8.0 (8.03, 8.0.4) but thought it was fixed by 8i.
John
[EMAIL PROTECTED] wrote:
Hi,
Is this
It will perform the update regardless of current value of the column. The
value checking is only done if
1. You have specified a where clause
2. There is a check constraint that would require such check
3. You have a explicit condition check in pre or post update trigger that
would require it.
Dear All,
I am totally out of my depth here and this is a production db which needs to
be restored urgently.
I shall explain my scenario first. Our application team had lost some data
after last Wednesday night's
backup. They have a tool to have a dump of the data from the database from
which
I believe the scripts to create the various stored procedures come with
the Enterprise Edition but Replication is not something that Oracle
does on its own.
At best, the packages are automatically created when you create the
database. There is a LOT of work you have to do on your own to set up
Samir,
It looks like your Rman commands are not being passed to Rman, and are
instead being executed by ksh.
Try moving all of your Rman command into a separate file, and changing your
rman command to:
rman target / catalog rman_sid1/rman_sid1@rman817 auxiliary / cmdfile (rman
command file
Helen: You could try http://www.examcram.com. Also, I just found Oracle's
list of test objectives.
http://www.oracle.com/education/certification/objectives/index.html?content.
html
You may just want to consider going ahead and buying the study books. Here
are the Sybex books.
Three words: TUNE THE SQL.
Database performance is 80% SQL Tuning and 20% database tuning. It would sound
like you've got a statement or two that is doing a whole bunch of full table
scans, probably somewhere inside a nested loop.
Take a look inside $ORACLE_HOME\sqlplus\admin for the
Gene - The $40K is the Enterprise Edition pricing as I recall. Can you move
to Standard Edition? If you are using EE features, then chances are that MS
SQL won't do the job. Also you can point out the eWeek benchmark between
Oracle and MS SQL.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
I am trying to determine what Oracle officially considers foreign objects in the
SYSTEM tablespace. If you check out Note 122669.1, section 7.1, Oracle recommends a
query to find foreign objects in your system tablespace. This query will report such
users as:
AURORA$JIS$UTILITY$
CTXSYS
Close, but no cookie. Look in the Admin guide, appendix A-1. There is some
overhead that you also need to take into consideration.
Dick Goulet
Reply Separator
Author: Bernard; Gilbert [EMAIL PROTECTED]
Date: 4/8/2002 4:58 AM
How can I
Here are excerpts from a thread posted by Jim Hawkins and Jared Still back in February.
Subj: Just Got Back from SqlServer 2000 training
On Mon, 18 Feb 2002, Jim Hawkins wrote:
During the class, I kept a list of all the I can't believe this is
really the case with SQL*Server... items, and
Your input to RMAN should be a script or here list. Scrap the shell script, put
your run script into a file, run RMAN from the command line and call the rman run
script that you just created.. Also, set NLS_DATE_FORMAT and NLS_LANG. Depending on
your database version the to_date function
Hi Samir,
Have you got your environment variables set up correctly. These would be the
following ones
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
export NB_ORA_SERV=server name
export NB_ORA_CLIENT=client name
export NB_ORA_SCHED=
export NB_ORA_CLASS=
These will all be set up in the
It is truly impossible to calculate the exact storage capacity for an
Oracle database block, for several reasons:
* some data structures (ITLs, table chart, row chart, etc) grow and
shrink due to the current state of transactions on rows in the block
* uncommited DELETEs and UPDATEs
Hi,
Greetings,
I am on the preparation for my OCP 8i Network Administration exam. I
welcome any tips or questions or model papers. So that i can prepare myself
well for the exam.
Looking forward to your inputs,
With best regards,
Muths
I'm hoping that you have a sev 1 TAR open on this, as well. Keep
pestering them if you haven't had a response; keep the TAR status at
IMMEDIATE RESPONSE REQUIRED (by responding multiple times) whenever you
hit the ball back to them. Also, be sure that all relevant facts are
recorded online
is there a back-end way to effect an alter tablespace rename to ... type
of thing?
yes, I know Oracle doesn't support mucking with the data dictionary, but . .
.
thx
-bill
Bill Magaliff
Framework, Inc.
914-631-2322
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
I have couple question. We need to set up 15 trainer
in the training room by tomorrow for a pl/sql class. I need to set up
utl_file_dir for them. This is NT environment.
question 1: If I create 15 users in oracle, do I need to ask Nt admin
to create system users for them as well?
2: It should be
1.You should study gui's. There are about 10 questions .
2.There are a few question about command line utilities and their
parameters.
3.Connection Manager is important.
thats all which I can remember
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Jay and Tom,
Thanks a million for your replies. I have now ran the script by creating it
and
then executing it from the RMAN prompt. It worked but I got the following
error :
rman target / catalog rman_sid1/rman_sid1@rman817 auxiliary /
Recovery Manager: Release 8.1.7.2.0 - Production
Paul - The only book I've found specific to Oracle replication is: Oracle
Distributed Systems by Charles Dye. It is pretty good. Replication isn't the
easiest thing to learn.
The fundamental questions to ask are: is your application designed
to work with replication? Are you just trying
Jay,
I always set up my production databases having SYSTEM, SYS, and DBSNMP with
default tblsp of SYSTEM; SYS gets temp tblsp of TEMP. Users like ORACLE,
OUTLN, TRACESVR, ORDSYS, etc. get TOOLS tblsp for default (and TEMP for temp
tblsp). I have never had any problems doing it this way.
Thank
I am running the following (Oracle suggested - 8i) query to get the biffer hit ratio.
This is our production Apps database. The numbers for logical and physical reads seem
VERY high (especially phys_reads, which obviously causes our hit ratio to drop to 0).
What could have caused this?
SQL
Roland,
I think you have a quote in the wrong place:
If A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG = 0 '' ||
Should probably read:
If 'A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG = 0 ' ||
Cheers,
John Thomas
-Original Message-
Sent: 08
2. like this
utl_file_dir =g:\oracle\utl_file,
g:\oracle\utl_file\change_svceng, g:\oracle\utl_file\change_usage
3. server
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, April 08, 2002 6:13 PM
I have couple question. We
Samir,
Glad I could help with your initial problem.
I'm afraid I can't help you here. I've never done this before. Over to
Jay...
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, April 08, 2002 10:25 AM
To: 'Jay Hostetter'
Cc: '[EMAIL PROTECTED]';
you really don't want to do this by mucking in the data dictionary.
the only SUPPORTED way is to export, drop the tablespace, recreate it
with the correct name,grant the user (or users) quota on the new
tablespace while revoking quota on all others (so they are forced into
this one) and import.
Hi
1.No, Utl_file writes as the Oracle process
2. I believe it is per instance and not per user. (you can create 15
directories and put all 15 in the init.ora file)
3. Utl_file writes on the server, not client
jack
Hi,
Forgive my ignorance but if I look at your connect string you connect to
both the target as auxiliary with the /
This in my opinion means that they both connect to the same instance and
judging from the error and what you wrote it looks as if you are connecting
to production with your
Paul, what's your reasoning behind this? I have always changed the default
and temp tablespace of everything except SYS to something else. I was under
the impression the SYSTEM tablespace should only hold the data dictionary.
Lisa Koivu
Oracle Database Tank Rash.
Fairfield Resorts, Inc.
Hallo,
I have some trouble to get this pl/sql code right. Anyone whpom could help me with
this. It is important.
Hallo,
I have some trouble with this pl/sql procedure. I would like
that this lvsql to be run only if the field Borttags_flagg = 0 but i get an error in
the if statement,
Hi All,
We forgot to export the variables export.
Jack
Jared Still
Not an easy question.
Set up a folder (directory) on the NT server called STUDENTS. Set your
utl_file_dir parameter to that folder. From the server's SERVICES panel,
stop and start the instance (so the parameter will take effect). Under
STUDENTS, create folders for each of your students and
But when I have fixed that error and then have the
then statement
put before the lvsql statement
I get this errormessage:
What does that mean? How to fix it?
PLS-00103: Encountered the symbol THEN when expecting one of the following:
( - + mod null an identifier
a double-quoted
The auxiliary database needs to have a remote_login_password file. This can
be created running the orapwd command
$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs orapwSID password = xx
entries=10
Then add the line remote_login_passwordfile=exclusive to the init.ora and
start the database in
Please excuse my idiotic curiosity.
Why do you need 2 listeners on the same machine?
I always install the listener of the higher version and disable the previous
one.
Yechiel Adar. Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday,
I am trying to user SQL*Loader to load some tables in my 8i database. The
data will not load. It seems to have to do with the format. In particular
the date format. Can anybody help? I have messed with this for 2 days.
Here is my data file (only 5 rows displayed):
Thanks Arslan, I appreciate your timing response. Now the last question,
for the r/w permission on the directory, if I created all the users in
oracle, like user01,user02... I am not sure how to grant permission to
the directory?
Joan
Arslan Bahar wrote:
2. like this
utl_file_dir
Given that a 1 GHz CPU can do about 100,000 logical I/Os
per second, and the largest machine is currently (I think)
only 128 CPUs, I can only guess three possibilities:
Your instance has been up for the last 500 years
The statistics numbers don't match the ones that the
Oracle code is supposed
I am with Lisa. But then again there are folks out there who are still
scared to change the pctincrease to 0 on the SYSTEM tablespace. I no longer
care unless its on one of my databases. Sometimes you just can't teach a
dog new tricks:-(
-Original Message-
Sent: Monday, April 08, 2002
I joined in a bit late on this thread, so you might have your problem fixed. Your
SID_LIST_LISTENER entry in the listener.ora should say SID_LIST_LISTENER816 and
SID_LIST_LISTENER817. When starting the listener, do the following:
(w/environment set for 816) lsnrctl start listener816
Glenn - V$SYSSTAT holds cumulative values since the instance was started.
You need to measure it over a period of time. Note the values, then note
them again in one hour, and measure the difference. Or use Oracle's utility
STATSPACK or the older utlbstat/utlestat. Even better, get Oracle
How can I do something like this;
select count(*) from prod.consenid into usercnt_tmp from dual
I want to send the amount of COUNT(*) into a variable. I get the following error
ORA-06550: line 5, column 36:
PLS-00103: Encountered the symbol INTO when expecting one of the following:
. , @ ;
Tim Gorman wrote
For a DUPLICATE DATABASE operation, you don't have to connect
to the TARGET at all, if I recall correctly; a DUPLICATE DATABASE operation
doesn't involve the TARGET. Sounds funny, until you consider that the
operation is reading from tape to the new AUXILIARY database instance.
David,
What does your log file show as the reason for failure?
John
-Original Message-
Sent: 08 April 2002 17:16
To: Multiple recipients of list ORACLE-L
I am trying to user SQL*Loader to load some tables in my 8i database. The
data will not load. It seems to have to do with the
select count(*)
into usercnt_tmp
from prod.consenid;
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod
Ahh...the files on the link are for Forms sending from a Windows client via
DDE (in which case the e-mail client matters), and not thru PL/SQL (in which
case the e-mail client doesn't matter), like the original question stated.
That's why I was confused.
Thx!
Rich Jesse
I got the same error when connecting in NT
with a user that is not an NT administrator.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, April 05, 2002 2:13 AM
the after trigger is missing the lone ranger?
ORACLE-L
If you've declared the variable usercnt_tmp, then you should be fine if you
just leave out the from dual bit and re-order the statements, e.g.,
select count(*)
intousercnt_tmp
fromprod.consenid ;
hth,
-Roy
Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension
Hello Bunyamin
We have the same problem.
I think that you can solve it with LDAP and
enterprise users.
Yechiel Adar
Mehish
- Original Message -
From:
Bunyamin K. Karadeniz
To: Multiple recipients of list ORACLE-L
Sent: Friday, April 05, 2002 11:15
PM
Subject: very
Hum, I could be reading this wrong but it looks like you are converting a
char to a date and then putting it into a char column If its a char on
the table then don't convert it to a date first. Otherwise change the data
type to date.
DATETESTED char to_date(:DateTested,'mm/dd/ hh:mi:ss
John, Jack, Tom, Jay and all those who replied,
Thanks so much for ur help. I have been able to resolve my problem. I was
connecting
to both the target and auxiliary databases with '/' as the connect string
and as a result,
RMAN was getting confused. I had to necessarily create a password file
I've got the following SQL statement that is running very long on a nightly
data load. The problem is the TO_CHAR function which is preventing
me from using the index on this small (20,000-row table).
This is an 8.0.4 database so it is not possible for me to use
make this a function-based
Here is an example of my logfile that it is generated:
SQL*Loader: Release 8.1.6.0.0 - Production on Mon Apr 8 10:06:31 2002
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Control File: app_dev.testcaseuatstatus.ctl
Data File: app_dev.testcaseuatstatus.dat
Bad File:
Congrats, glad we have been of use. And probably a faster response than
logging a tar
John
-Original Message-
Sent: 08 April 2002 18:38
To: Multiple recipients of list ORACLE-L
John, Jack, Tom, Jay and all those who replied,
Thanks so much for ur help. I have been able to resolve my
Hi All,
I am back againand yes, my script didn't work completely. It did
write the data files
to the respective locations but it returned the following error during the
process of duplicating
the db :
RMAN-03021: executing script: Memory Script
RMAN-03022: compiling command: set
Dave,
I just ran the following and it worked just fine:
Sql_Loader file:
LOAD DATA
INFILE 'test_loader1.dat'
replace
INTO TABLE test
(
DATETIME POSITION(01:21) CHAR
to_date(rtrim(ltrim(:datetime,),),'-mm-dd-hh24.mi.ss'),
USERID POSITION(23:30) CHAR)
Data File:
Hello,
It should not be all that uncommon. We have 7 databases each on our
development and test machines that are tied to their production
counterparts, and, over time, some of the databases have lagged behind
others (lots of reasons for that, esp. mgt. priorities), leaving us with
multiple
I have not got a system to test this out on at the moment but can you do a
substr on the to_char so that the format matches the date_key
Something like substr((TO_CHAR(:b1,'DD-MON-'),11)
John
-Original Message-
[EMAIL PROTECTED]
Sent: 08 April 2002 18:57
To: Multiple recipients of
Leave your tnsnames.ora files alone for now - they aren't relevant to getting the
listeners started. Post your current listener.ora files and the output from your
commands to start the listeners. Make sure they are down before you try to start them.
Jay
[EMAIL PROTECTED] 04/08/02 01:56PM
Cherie,
Couldn't you do
SELECT DATE_KEY
FROM DATE_DIM
WHERE ORACLE_DATE = trunc(:b1)
and oracle_date trunc(:b1) + 1
which should at least give a range scan.
Iain Nicoll
-Original Message-
Sent: Monday, April 08, 2002 6:57 PM
To: Multiple recipients of list ORACLE-L
I've got the
Why not just run the 817 listener for both databases? Only one
listener can be bound to a port, so using your config you could run 816
on 1521 817 on 1522. But I'd stick with using just the 817 listener
on ports 1521 1526.
Janet Linsy wrote:
Hi,
I have two databases ORCL817 and
You need to change this line
set until time 'to_date(''20-MAR-2002 20:00:00'',''DD-MON-HH24:MI:SS'')';
to
set until time '2002032020';
This is bug 1887009. This isn't fixed until 9.0.2.
You must set
NLS_DATE_FORMAT=MMDDHH24MISS (or your favorite date format)
and
NLS_LANG=
Could you maybe calculate a range of date values that encompasses the period
you want and use BETWEEN on the raw date column? I'm thinking something
along the lines of:
SELECT DATE_KEY
FROM DATE_DIM
WHERE ORACLE_DATE BETWEEN TRUNC(:b1) AND TRUNC(:b1) + .9 ;
but like, more elegant.
John,
I will test it out. Thanks for your helpful recommendation.
Cherie
John Hallas
I don't think you can do it.. I mean, you could change it to trunc the
oracle_date field (that eliminates the minutes) and then do a to_date
of :b1 but you will still be operating on the oracle_date field.
Okay, I HATE to suggest this, but since the table is small:
add another field to the
Paul,
I know what. . . to prevent whining in the future, suggest creating a hidden
file for the rollback tablespace on /u004 and a soft link from the proper
location. No wait, don't do that, they might go for it. ;)
Mike
-Original Message-
Sent: Friday, April 05, 2002 9:53 AM
To:
Jay,
Thanks so much for ur help. Could u please tell me whether I shall have to
set the NLS_DATE_FORMAT and NLS_LANG in the parameter file of the auxiliary
db alone or on
the target db (the main prod db) as well ???
Regards,
Samir
Samir Sarkar
Oracle DBA
SchlumbergerSema
Email : [EMAIL
If you let the Assistant create scripts to create the database, you
will find that Oracle now automatically changes SYSTEM's default
tablespace to TOOLS.
The ONLY account that should have a default tablespace of SYSTEM is
SYS.
Rachel
--- Sherman, Paul R. [EMAIL PROTECTED] wrote:
Jay,
I
Iain,
I will do some tests. Theoretically, yes, a range scan should be better
than a full table scan.
Thanks for your helpful recommendation.
Cherie
Something like:
WHERE ORACLE_DATE between trunc(:b1) and trunc(:b1) + 1 - 1/(24*60*60)
-Original Message-
Sent: Monday, April 08, 2002 12:57 PM
To: Multiple recipients of list ORACLE-L
I've got the following SQL statement that is running very long on a
nightly
data load. The
Cherie,
How about using the TRUNC function on the date field. That will use
only thre ,MM,DD of the ORACLE_DATE column. Then you will be
comparing like columns without going through the to_char conversion.
WHERE TRUNC(ORACLE_DATE) = TRUNC(:b1)
Ron
ROR mª¿ªm
[EMAIL PROTECTED] 04/08/02
David,
In the FIELD clause, shouldn't it be OPTIONALLY ENCLOSED BY ?
-Original Message-
Sent: Monday, April 08, 2002 12:16 PM
To: Multiple recipients of list ORACLE-L
I am trying to user SQL*Loader to load some tables in my 8i database. The
data will not load. It seems to have to do
I am a bit confused now Samir. Your earlier script did not mention a
I cannot see where you have the line duplicate target database to
test
Can you post you're revised script and we can check it out
John
-Original Message-
Sent: 08 April 2002 19:04
To: Multiple recipients of list
Ron,
the TRUNC function will also prevent the use of an index on the oracle_date
column.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, April 08, 2002 2:54 PM
To: Multiple recipients of list ORACLE-L
Cherie,
How about using the TRUNC function on the
Sure John..here it is :
run
{
set until time to_date('20-MAR-2002 20:00:00','DD-MON- HH24:MI:SS');
allocate auxiliary channel dupdb_d1 type 'SBT_TAPE';
setlimit channel c_dlt1 kbytes 67108864 maxopenfiles 128 readrate 256;
setlimit channel dupdb_d1 kbytes 67108864 maxopenfiles 128
let's face it Rachel, the date column is probably incorrect as the table was
designed. knowing that it is important in queries, and that the minutes
cause problems during query, your suggestion should have been incorporated
in the original design (or truncing the oracle_date field via a
How about something like:
SELECT DATE_KEY
FROM DATE_DIM
WHERE ORACLE_DATE between trunc(:b1) and trunc(:b1)+86399/86400;
It's not the prettiest thing in the world, but it keeps the use of the
index on ORACLE_DATE and an adjacent comment that there are 86400
seconds in the day should make it
Out of curiosity I decided I wanted to look at what composed the
extent map in locally-managed tablespaces.
I dumped the first 5 blocks of the tablespace's first datafile with
'alter system dump datafile ...' The results surprised me, as they
appeared to consist of almost no data. The LMT in
Hi,
I am still not clear how to do this, I created 15 users in
oracle...user1~user15. On the server site, utl_file_dir should be set to
d:\dataware\sisfiles\user1. to user2. I checked the property of
d:\dataware\sisfiles, we have sis group have all the permission on the
folder. How can I set
I suppose if you wanted to collect statistics about hourly usage, then
the minutes info would be necessary
but then, most people don't think about how they really want to use the
date when they add a date field
--- Mercadante, Thomas F [EMAIL PROTECTED] wrote:
let's face it Rachel, the date
Hello,
Well, if that's the case, then, going forward, I suppose it's ok to keep
SYSTEM objects in TOOLS, but it sure seems strange.
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (office)
fax- 781-278-8341 (office)
email - [EMAIL PROTECTED]
-Original Message-
Sent: Monday,
Simple snapshot replication (provided by materialized views or mviews) is
enabled when you use the Enterprise Edition of the database at any time as
long as
job_queue_processes is 0, and, of course, you have defined some mviews.
This is one way replication.
If you want 2 way (advanced,
Tom,
I realize that there would not be an index but I was trying to
eliminate some overhead by using the TRUNC function as compaired to the
to_char for the fields.
Cherie,
If the table is not to large how about pinning it to save on disk
reads?
Ron
ROR mª¿ªm
[EMAIL PROTECTED] 04/08/02
Following on from my previous note:
Jeremiah,
From your bitmap control,
You have FF occurring 3 times followed by 3F which is
255, 255, 255, 63 which is
0011
So, least signficant bit first,
1100 which is
used, used, ... (30
Hi,
After I issued lsnrctl start ORACL816, the 816
listener started, but the status shows the listener
supports no services.
STATUS of the LISTENER
Alias LISTENER816
Version TNSLSNR for Solaris: Version
8.1.6.0.0 - Production
Start
Hello List,
I am seeing Locks and the OS process is SNP process , I have to run the same
job which will refresh the MVs. I am stuck due to the locks on the database
, when I have tried to kill the session , it says me its is Marked for kill.
Can anybody suggest me what to do ???
Its one kind of
Jeremiah,
Let me explain before guru X$GOPAL woke up. I guess time is midnight
in India.
Here are the some lines before your dump:
Start dump data blocks tsn: 1 file#: 2 minblk 3 maxblk 3
frmt: 0x02 chkval: 0x type: 0x1e=KTFB Bitmapped File Space Bitmap
File Space Bitmap Block:
BitMap
Jeremiah,
Everything looks normal. Block #3 shows the first couple bytes as
FF3F000 When you decipher FF3F, you will see 30 (out of
a possible 32) bits in those 4 bytes (a.k.a. 8 nibbles) set to 1 instead
of 0, indicating that those are used extents. Your COUNT(*) on
Set the environment variables for your shell. You don't have to change your database
settings.
e.g. (in ksh)
NLS_DATE_FORMAT=MMDDHH24MISS
export NLS_DATE_FORMAT
NLS_LANG=AMERICAN_AMERICA.WE8DEC
export NLS_LANG
Jay
SARKAR, Samir [EMAIL PROTECTED] 04/08/02 01:44PM
Jay,
Thanks so much
1 - 100 of 121 matches
Mail list logo