What happens if you do it logged in as CTXSYS and not system/manager?
-Original Message-
Sent: Thursday, April 18, 2002 12:58 PM
To: Multiple recipients of list ORACLE-L
This is a valid user in database but not to export somebody has any idee
o solve it.
-00010 I need help
What happens if you do it logged in as CTXSYS and not system/manager?
-Original Message-
Sent: Thursday, April 18, 2002 12:58 PM
To: Multiple recipients of list ORACLE-L
This is a valid user in database but not to export somebody has any idee
o solve
Sinardy Xing wrote:
Hi all,
I try to change the error message to French,
Don't do that. French-speakers have to translate back to English to
understand what they mean.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
: RE: BITAND need help
Do a:
desc dual
SQL desc dual
NameNull?Type
---
DUMMYVARCHAR2(1)
SQL
You are trying to do a bitand on a varchar2 column.
Scott Shafer
San
select bitand(4,4)+0 from dual;
--- Sinard Xing [EMAIL PROTECTED] wrote:
Hi,
Can someone help me with this please
What cause the error ?
SQL select bitand(4,4) from dual;
ERROR:
ORA-00932: inconsistent datatypes
no rows selected
Sinardy
--
Please see the
The reason behind the oddity is probably
that bitand() is defined (see standard.sql)
to return a binary_integer (it used to return
a number in earlier versions) and pure SQL
does not recognise that type, so you need
a method for coercing the result to a number.
It is probably slightly cheaper
will not accomplish great things. Simply become insane and
desperate.
-Original Message-
From: Sinard Xing [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 8:48 PM
To: Multiple recipients of list ORACLE-L
Subject: BITAND need help
Hi,
Can someone help me
To: Multiple recipients of list ORACLE-L
Subject: RE: BITAND need help
Do a:
desc dual
SQL desc dual
NameNull?Type
---
DUMMYVARCHAR2(1)
SQL
You are trying to do a bitand
Hi,
Can someone help me with this please
What cause the error ?
SQL select bitand(4,4) from dual;
ERROR:
ORA-00932: inconsistent datatypes
no rows selected
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinard Xing
INET: [EMAIL PROTECTED]
Fat
of list ORACLE-L
Subject: Re: URGENT: need help by point in time recovery
This reminds me of something I always wanted to try to work
out. It seems like you should be able to rebuild part of a
db, so that the recovery of a certain tables data would be
faster. That way you don't
: Thursday, February 14, 2002 8:14 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: URGENT: need help by point in time recovery
This reminds me of something I always wanted to try to work
out. It seems like you should be able to rebuild part of a
db, so
Message-
From: Ray Stell [SMTP:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 1:38 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: URGENT: need help by point in time recovery
On Fri, Feb 15, 2002 at 10:03:48AM -0800, Dejam, Ruth wrote:
We use that method for our 8.0.6
Betreff: Re: URGENT: need help by point in time recovery
This reminds me of something I always wanted to try to work out. It seems
like you should be able to rebuild part of a
db, so that the recovery of a certain tables data would be faster. That way
you don't spend the time reading all
Title: URGENT: need help by point in time recovery
Hi list,
I have a urgent problem. One of our developers has deleted all rows of a table on production database (database of a customer from us). We have a nightly cold backup and database is running in archivelog mode. On same server we
Title: URGENT: need help by point in time recovery
Hi
Volker...
You
should be able to do this... Just make sure you use a "using backup
controlfile" on your recover command... Alternatively, you could mount the
database and rename the datafiles instead of recreating the c
:
[EMAIL PROTECTED] Subject: URGENT: need help by point in
time recovery
om
Hello all,
I have attached an sql file containing a set of sql's (6) of them, which gives me
information regarding table fragmentation. What I need to do is instead of writing
seperate sql's, I need to write a procedure, where in I pass the owner and table name
and then the result comes out,
Yeah I am reading, but if I could get a framework for a procedure, referring to my
sql's, then that would be a big help.
Please help.
rgds,
raja
--
On Wed, 28 Nov 2001 11:25:01
Kevin Lange wrote:
Two books . Oracle PL/SQL Programming and Oracle Built-in
Packages. Both from
WOW ! all those new column names wth quirky names.
Well here is the procdure. make sure you got the GRANTs right
in order to compile it.
Also check to make sure I got the your_variable/my_variable match right.
hth
robert chin
CREATE OR REPLACE PROCEDURE table_fragmentation_info
( v_table IN
raja,
I would recommend that you heed Kevin's advise .. in
the meantime .. here is a quick start e.g. for what
you are looking to do ..
create procedure Blah (
para_owner in varchar2,
para_table in varchar2) is
cursor c1(v_owner varchar2, v_table varchar2) is
select
I think that the following statement is keeping this application from using
an index in my cost-based execution plan. This is an 8.0.4 database so I
don't have the option of creating a function-based index.
I'm not that great with SQL. Can anyone help me rewrite this statement so
that I don't
Hmm,
my_limit_date DATE:= trunc(sysdate) - 6; -- !!! only 6
erh.arrival_dt my_limit_date
JP
On Thu 15. November 2001 16:00, you wrote:
I think that the following statement is keeping this application from using
an index in my cost-based execution plan. This is an 8.0.4 database so
: [EMAIL PROTECTED]
Subject: Re: Need help rewriting SQL with
TRUNC function
11/15/01 10:13
Jan Pruner
[EMAIL PROTECTED] To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject: Re: Need help
rewriting SQL with TRUNC function 11/15/01 10:13
I think that the following statement is keeping this application from using
an index in my cost-based execution plan. This is an 8.0.4 database so I
don't have the option of creating a function-based index.
I'm not that great with SQL. Can anyone help me rewrite this statement so
that I don't
(trunc(sysdate) - trunc(erh.arrival_dt)) = 7
becomes
- trunc(erh.arrival_dt) = 7 - trunc(sysdate)
becomes by negating
trunc(erh.arrival_dt) = trunc(sysdate) - 7
becomes
erh.arrival_dt = trunc(sysdate) - 7 + 0.9
hth
connor
--- [EMAIL PROTECTED] wrote:
I think that the following
Wouldn't this introduce a time-of-day dependency on the result?
Instead, how about:
(trunc(sysdate) - erh.arrival_dt)) 6 AND
(ie. strictly greater than six days ago)
- Bill.
At 08:30 15/11/01 -0800, you wrote:
Cherie,
Change the clause as follows
orig == (trunc(sysdate) -
Hi Everyone,
We have been experiencing some I/O issues; and the systems support team (HP)
thinks that we should bump up our OS buffer cache. Currently we are sitting
at 150MB; after researching on Metalink the recommendation from Oracle for
HPUX is to have a max of 128MB of buffer cache. I have
We are having 134MB for buffer cache with same platform and version. You can
go upto 256MB,if you want. There are other list members like Kirti who can
give better explanation of this.
Regards
MOHAMMAD RAFIQ
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
Hi all,
Can someone tell me whats wrong with my script ?
CREATE DATABASE TEST
LOGFILE (
'/test/redo01.log' SIZE 10K,
'/test/redo02.log' SIZE 10K,
'/test/redo03.log' SIZE 10K
)
MAXL0GFILES 6
MAXINSTANCES 4
You don't need to put any Bracket after keyword 'LOGFILE'
See following lines...
CREATE DATABASE OHIR
LOGFILE 'D:\Oracle\oradata\OHIR\redo01.log' SIZE 1024K,
'D:\Oracle\oradata\OHIR\redo02.log' SIZE 1024K,
'D:\Oracle\oradata\OHIR\redo03.log' SIZE 1024K
MAXLOGFILES 12
MAXLOGMEMBERS 2
Try to remove the brackets.
Rgds/Jeram
-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wednesday, September 05, 2001 2:27 PM
Hi all,
Can someone tell me whats wrong with my script ?
CREATE DATABASE TEST
LOGFILE (
'/test/redo01.log' SIZE 10K,
Chk the spelling of maxlogfiles. You have used 0(zero) instead of 'O'.
--
On Tue, 04 Sep 2001 23:55:42
Sinardy wrote:
Hi all,
Can someone tell me whats wrong with my script ?
CREATE DATABASE TEST
LOGFILE (
'/test/redo01.log' SIZE 10K,
of list ORACLE-L
Subject: Create Database ORA-907 need help
Hi all,
Can someone tell me whats wrong with my script ?
CREATE DATABASE TEST
LOGFILE (
'/test/redo01.log' SIZE 10K,
'/test/redo02.log' SIZE 10K,
'/test/redo03.log' SIZE 10K
Title: Oracle 8i Upgrade Proposal - Need Help!
Hello Ladies and Gentlemen,
I need to present a proposal to management on Upgrading on of our databases from Oracle 7 to 8i. I was wondering if anyone out there already has done this. If so, can you please e- mail me a copy of this proposal
Hi all,
1. I have table emp (ename, dept, sal)
2. I do
SELECT 'NAME : ' || ename || ' DEPARTMENT : ' || dept || ' SALARY : ' ||
sal
FROM emp;
Result:
NAME : JAMES DEPARTMENT : LAB ENGINEER SALARY : 2000
NAME : BOB DEPARTMENT : DRIVER SALARY :
Message-
From: Sinardy [SMTP:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 10:41 PM
To: Multiple recipients of list ORACLE-L
Subject: SQL+ SELECT statement need help
Hi all,
1. I have table emp (ename, dept, sal)
2. I do
SELECT 'NAME : ' || ename || ' DEPARTMENT
, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L
Subject:SQL+ SELECT statement need help
Hi all,
1. I have table emp (ename, dept, sal)
2. I do
SELECT 'NAME : ' || ename
statement need help
Hi all,
1. I have table emp (ename, dept, sal)
2. I do
SELECT 'NAME : ' || ename || ' DEPARTMENT : ' || dept || ' SALARY
: ' ||
sal
FROM emp;
Result:
NAME : JAMES DEPARTMENT : LAB ENGINEER SALARY : 2000
NAME : BOB DEPARTMENT
Hi all,
When I do
Select * from v_$sga;
NAME VALUE
--- ---
Fixed Size ###
Variable Size ###
Database Buffers###
Redo Buffers
It seems that the column format of col. VALUE is less.
Before giving the first command give the following command
column value
It will display the current column format of column VALUE
Now second SELECT doesn't gives any problem 'coz col format is assigned on
col. VALUE not on VALUE + 0.
Hi all,
Thank you all, It's work now
I must clear it using
clear column
or exit from sqlplus
and run it again
Thanks
Sinardy
-Original Message-
Graham
Sent: Thursday, 23 August 2001 7:51 PM
To: Multiple recipients of list ORACLE-L
Sinardy,
assuming that this has been done in
Are you rebuilding indexes with unrecoverable/nologging and parallel clause
or simple 'alter index index_name rebuild tablespace tbs_name', which is
definately slow then using above options500/600MB indexes may take
around 30/35 minutes depending of your parallel clause and cpu
Thank you everyone who replied. All suggestions were very helpful. I am
bebuilding my indexes in a different tablespace. It runs very very slow..
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 3:51 PM
Lyuda;
1.
I meant EBUILDING. That is what a long day of slow rebuilding indexes
can do to you.:-)
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 9:32 PM
Thank you everyone who replied. All suggestions were very helpful. I
Lyuda;
1. Create a new tablespace for the indexes on a seperate drive. Make sure
you do this with a much more reasonable datafile size. (Watch it here
maybe they did the big size because they were running out of possible files
-- see the max_datafiles parm on the Create Database command)
Hi Lyuda
This is not a nice situation to bee in, but the god new is that oracle can help
you since you are using version 8.1.6 !
You can use the ALTER INDEX index-name REBUILD TABLESPACE
new-tablespace_name; to move the index to a new tablespace and this can even
be don online with ALTER INDEX
Lyuda,
You didn't say if you have other disk space available or not. If you do I would create
the index/indexes tablespace/s on different drives then drop them from the original
location. After you get breathing room you can reorg the database to a more
comfortable setup. When you have removed
You can check alter index clause and you will find parallel option. You may
use parallel 5 safely being default in initSID.ora. However it will start
building 5 times extent in temp tablespace before completion of rebuilding.
With rebuilding large indexes on regular basis we have to use all
Hi List,
I have a monster tablespace 36 G with two datafiles 32 G and 4 G. Don't ask
me who created such a file because I don't know. I am trying to rescue the
database that has multiple problems. Something you've never seen before.
Bye the way, did anyone ever run a test how much stuff you
Hello all,
A very basic question; the background processes, smon, pmon, etc. do they have an
executable name like smon* etc. or pmon* in some bin directory of oracle? Or how do
they start? like eg. BMC' Patrol agent when it runs is run because there is an
executable called PatrolAgent, is it
Hi all
Lets say I have a table:
f1 char(10)
f2 char(2)
f3 number
where f1 is a name, f2 is a code and f3 is a number.
What I want to produce is a report that looks
something like this:
F1 F2 IS A F2 is B F2 IS C F2 is X
f1f3f3 f3
f1f3
Hi all
Lets say I have a table:
f1 char(10)
f2 char(2)
f3 number
where f1 is a name, f2 is a code and f3 is a number.
What I want to produce is a report that looks
something like this:
F1 F2 IS A F2 is B F2 IS C F2 is X
f1f3f3 f3
f1f3f3 f3
I dont want to sound rude here, and my comments are NOT directed at you personally.
What is the standard of these OCP's, when a person who has not worked with oracle, can
pass them, for the sake of discussion it does not matter which tests they were? It
seems doing an OCP is a complete waste
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
[EMAIL PROTECTED]Sent: Wednesday, 20 June 2001 11:15
AMTo: Multiple recipients of list ORACLE-LSubject: Need
help getting startedThis is kind of a different Oracle question. Does anyone have any
Viraj, hahahahah, it couldnt have been said any better :), i've been
thinking that way for years as well as a few others on the list :)
joe
Viraj Luthra wrote:
I dont want to sound rude here, and my comments are NOT directed at you personally.
What is the standard of these OCP's, when a
Dear Viraj,
I can totally understand how you feel.
But I hope you can appreciate that it takes a lot of courage and
perseverance for a person who doesn't know Oracle to take any of the OCP
papers. Many of us have to do a lot of additional studies on top of the
Oracle training material
My first question is what is your field of study in school? Is it computer related?
Have you graduated, many employers want to see you graduate before they will hire you.
Have you asked any of your larger companies about any IS extern programs that they
might have. If you have graduated, have
l.comTo: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent by: cc:
root@fatcity.Subject: Need help getting
I agree, if you have no experience and take the exams it will give you some
level of knowledge about oracle. I have started taking these exams and
recognize one issue with getting certified. It's great and all, but it's
like any other test. You can study your arse off and pass with flying
.
Cheers!
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
-Original Message-
From: Joseph S. Testa [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, June 20, 2001 6:25 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Need help getting started
Viraj
Title: RE: Need help getting started
Karen, for what it's worth:
What did you study in college? Studying CSCI in college is absolutely not a prereq for getting into technology but it at least demonstrates that you can think that way. I did study CSCI and I think half of it was a waste
At 11:15 PM 6/19/01 -0800, you wrote:
What is the standard of these OCP's, when a person who has not worked with
oracle, can pass them, for the sake of discussion it does not matter which
tests they were? It seems doing an OCP is a complete waste of time!
Uh, couldn't the same comment then be
Joe, I don't think we've enough information to state that she doesn't
have Oracle running on her Linux machine at home, and hasn't diligently
practiced and studied. I learnt Java in a similar way before getting my
first Java developer job back in '96. I would expect people on this
list to be a
Just as an addendum to what others have said. Many goverment offices
accept volunteers. Have you tried going to your city/county goverments
and if possible state? Also, hospitals also accept volunteers.
Terry
[EMAIL PROTECTED] wrote:
This is kind of a different Oracle question. Does anyone
I'm kind of in the same boat as Karen... except that I'm working as a
developer right now (not Oracle). My goal of becoming a DBA has taken a
year and a half to complete the certification track. I know the effort it
takes to get certified. Granted, there are a lot of things I leaned and knew
Hi all,
I recreated DBA role that provided by Oracle8i,
1. Create New_DBA_role identified by change_me;
2. Select 'GRANT ' || privilege || ' TO new_dba_role' FROM dba_sys_privs;
Create new dba user
3.Create user new_dba identified by password
default tablespace userdata
This is kind of a different Oracle question. Does anyone have any suggestions
how a person can land an entry level job. I do not work in the Technology
field but would very much like to. I have been going to school at night for
about two and a half years
and have the first two OCP developers
I need some help. I was an Oracle DBA with ADC Telecomm
in Minnesota and was laid off along with 7,000 other ADC
employees. The job market here in the TCs has been
very slow.
Any assistance finding another Oracle related position
would be greatly appreciated. Please contact me directly
Ken,
Welcome to the club. Are we starting a trend? At least
we're not competing against each other.
Good luck,
Yosi
[EMAIL PROTECTED] wrote:
I need some help. I was an Oracle DBA with ADC Telecomm
in Minnesota and was laid off along with 7,000 other ADC
employees. The job market here in
06, 2001 2:47 PM
To: Multiple recipients of list ORACLE-L
Subject: Need help tuning FTS
All,
I need some help in tuning a select statement that performs a
FTS. (The FTS
is deliberate !) It takes over 5 hours to run in our prod
instance, but
takes less than 10 min in our QA
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 2:47 PM
To: Multiple recipients of list ORACLE-L
Subject: Need help tuning FTS
All,
I need some help in tuning a select statement that performs a
FTS. (The FTS
is deliberate !) It takes over 5
recipients of list ORACLE-L
Subject: Need help tuning FTS
All,
I need some help in tuning a select statement that performs a
FTS. (The FTS
is deliberate !) It takes over 5 hours to run in our prod
instance, but
takes less than 10 min in our QA instance. The QA instance
was copied from
prod
I would recommend uping the parameter _DB_BLOCK_HASH_LATCHES by default
after I believe 2000 block buffers, it defaults to 1024 all the way up to
10 blocks buffers if i remember correctly. This will generate alot of
the #66 latch contention. This shouldn't equate to 6 hours compared to 10
cache value
in QA, but a low cache value in prod?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 2:47 PM
To: Multiple recipients of list ORACLE-L
Subject: Need help tuning FTS
All,
I need some help in tuning a select statement
Chris,
Thanks for your input !
One difference between our prod and QA instances is that the QA instance is
relatively idle - while average load on the prod instance is about 175
users, with less than 5% hitting the database hard at any given point in
time. I am unable to figue out why there is
Srini,
I am sure you have lots of users in Prod compared to QA :)
Anyway, the point is that you are suffering from hot block contention which
reflects itself in latch waits on 'cache buffer chain'. I remember that
Steve Adams has a SQL at his site that identifies blocks that are 'hot' - I
have
John,
Thanks for your input !
Unfortunately, this issue seems too weird ! (I know, I know, I shouldn't
be saying that as a DBA !!).
We have run that process three times today in prod in an effort to try and
isolate the issue. We have run it when only one other user was hitting the
prod database
Hi Srini,
isolate the issue. We have run it when only one other user was
hitting the
prod database heavily using a select stmt on unrelated tables - but the
problem still persists. There were no concurrent requests
running at the
time. The issue does not seem to be related to contention of
ummins.com To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED]Subject: RE: Need help tuning FTS
Hi,
I need some help...I am trying to use SQL loader
to load a flat file into a table...the problem I have is that
when trying to load a blank column into a date column...
this throws out an error...and the loader fails...do you know of a way of
how
to get around this problem...how can I
Hi,
Take a look at the nullif clause.
tom
-Original Message-
Sent: Tuesday, May 29, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L
Hi,
I need some help...I am trying to use SQL loader
to load a flat file into a table...the problem I have is that
when trying to load a blank
In the CONTROL file that describes the columns to load from the data file you can load
a FILLER type column desc into the destination table if the column does not exist in
the source data file. If the source data column contains nulls then a NVL will convert
a null to what ever you want to
Charles,
8.0.5 will work on Win2K, I've got it still installed and have no problems.
BUT, if your DB is 8.1.x then you're loosing some features by not upgrading the
client. As a for instance, the 8.0.5 SQL*Plus client will not support the
execute immediate statememnt in PL/SQL. The 8.1.6
Hi Listeners,
Do you recommend the latest version of the Oracle client for the
desktop?
Our current standard is Oracle 8.0.5. In preparation for Windows 2000,
we would like to migrate to a new version sometimes this
year. Is there a version you suggest we look at?
Thanks in advance,
Charles
Charles,
For Win2K...Oracle only supports the 8.1.6 Client or higher. We've
standardized on the 8.1.6 Client for our Corporate-wide rollout of the
Oracle Client utilizing Oracle Names for DB name resolution.
Ed Haskins
Oracle DBA
Verizon Wireless
-Original Message-
Sent: Monday,
Hi All,
Recently we moved the database(Oracle 8.0.5) from NT to Sun machine. Now
this database is going online very soon. When we were testing we observed
that, the application (select statement) is running very slow. (I don't know
how fast it was earlier). I have a feeling that it is not using
Hello, Uday,
First step, try ANALYZE TABLE ... COMPUTE STATISTICS for EVERY table
participating your query(es). Check and compare execution plan before and
after analyze.
HTH
Vadim Gorbounov
Oracle DBA
-Original Message-
Sent: Thursday, April 19, 2001 3:32 PM
To: Multiple recipients of
You have to ru explain plan for that statement.
You first have to create the PLAN_TABLE, you can do that running the script
$ORACLE_HOME/rdbms/admin/utlxplan.sql
Then, login to sql and run th following statement:
SQL explain plan for your-sql ;
then, run the following statement to obtan the
hi uday!
i strongly would recommend you to have a look at the execution
plan of your sql statement. you might also find my tool called
top100 quite useful in helping you to look at the execution
plans for all statement in your sga.
have a look at my web page at: www.materialdreams.com
do
Uday,
Your problem may have more than one component. There are three
immediate things I'd try/look at, one of which will provide you with
information, the other two that may or may not improve your
performance. For information on your select statement, start a trace on
the session, run the
select NAME,
VALUE
from sys.v_$sga;
vmstat (solaris command)
Sinardy
-Original Message-
Sent: Monday, 26 March 2001 8:12 PM
To: [EMAIL PROTECTED]
Importance: High
Hi Gurus,
does anyone has a script that detects in a database where a lot CPU is being
used and
Neena,
If I understand correctly, you have a server with the OS on it, and the
DB on a set of external drives - right?
Cable the external drives to the working server, reboot, and import the
volume groups.
Your database should be right there.
Regards,
David A. Barbour
Oracle DBA
Formerly
SET PAGESIZE 0 suppresses the headings
Rick
-Original Message-
From: L [SMTP:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 2:08 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [Q] SQL statement need help !!
I have following sql statemen when runninf does
Title: OFFTOPIC RE: Need help in moving LOB index
How far away is the tablespace?
You need to know this, because first you need to compute
tablespaces/mile before activating the LOB-Velocity filter.
This is a new 8i feature that some of the list gurus might
be able to help you
Winnie,
According to the SQL Reference for 8.1.6 (Create Table):
LOB_index_clause
This clause is deprecated as of Oracle8i. Oracle generates
an index for each LOB column. Oracle names and manages the
LOB indexes internally.
Although it is still possible for you to specify this
clause, Oracle
Oracle recommends against this.
LOB_index_clause
This clause is deprecated as of Oracle8i. Oracle generates anindex for each LOB
column. The LOB indexes are system named
and system managed, and reside in the same tablespace as the LOB data segments. It is
I have a public database link defined with userid-1.
Userid-1 has update permissions on table-a in database-b.
Userid-2 has no permissions on table-a in database-b.
Userid-2, in database-a, calls a package that contains the database link and
tries to update table-a in database-b.
The result is an
I'm sorry. The error is not that the user cannot use the database link.
The error is that Oracle does not want the user to update table-a in
database-b even though the user has update permissions.
Ron
-Original Message-
Sent: Monday, February 05, 2001 8:30 AM
To: Multiple recipients of
Let me rephrase it. The user defined in the database link has insert
permissions on table-a. The user calling the database link does not have
any permissions on any table in database-b.
Ron
-Original Message-
Sent: Monday, February 05, 2001 10:11 AM
To: Multiple recipients of list
101 - 200 of 200 matches
Mail list logo