Hi,
Within your *.sql script you can jump to the OS and give OS commands.
e.g: host sqlldr. (start with host).
I have used it with import and it works.
Jack
select *
from user_segments
is a good start..
hth
connor
--- Viraj Luthra <[EMAIL PROTECTED]> wrote: > Hello
all,
>
> How do I come to what tables are present in a
> particular tablespace and then when I found the
> table, can I come to know what amount of space it
> consumes?
>
> eg. I want
Hi Gurus,
I tried to drop unique index using "ALTER TABLE table_name DROP UNIQUE
(column_name);" unsuccessfully. How should I drop the unique index ? Please
advise. Thanks.
SQL> SELECT * FROM USER_IND_COLUMNS WHERE TABLE_NAME='SPY_ADHOC_PAYMENT';
INDEX_NAME TABLE_NAME
>From a money perspective - yes
>From a resource perspective - no, using the
obfuscation toolkit does add lots of cpu to your
processing (if you're handling lots of rows)
hth
connor
--- [EMAIL PROTECTED] wrote: >
> We are in the process of upgrading most of our
> databases to 8.1.7.1
> (Enter
How can I find the logical or physical I/O size on a Sun Solaris machine ?
Thanks,
~aslam
application/ms-tnef
Hello if there any testing tools for QA staff / developer to test on bulk
data which can measure it performance,efficient.of the
program/PLSQL/sqlscript ???
The function of the tools is , prepare bulk data , testing , generate
report .
If no such tools , what might be an advice ? Be
Title: Number Vs. Varchar2 Datatype
Hi list,
We are in the design phase of our new database and eventually there a number of feilds which are actually numeric say DEPARTMENT NUMBER or EMPLOYEE CODE (they dont contain any alphabat or special character) ,
The main decision to be made right n
HI ALL,
We have to load almost 3 millions records of average row size of 150 bytes.
We are importing data using sqloader with ROWS=4000 and bindsize=845 .
We have adjusted the rollback segment to almost 10 m with 8 extents enough
for single transaction size and considering 30% rollback overh
i guess you forgot to do
svrmgrl> archive log start;
> --
> From: SAMI SALEM[SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, May 30, 2001 5:03 PM
> To: LazyDBA.com Discussion
> Subject: archive redo logs on NT
>
> Hi DBAs,
>
> I'm having a problem with archive redo l
hi,
i created the package and the procedure after modifying the ip of our mail
server in the procedure body.
it gave no error during creation but is not executing the procedure
send_mail.
should i give it all four arguments. but it still not executing saying
ora-06512
what should i do.
i ve 8.1
hi DBA Masters:
If i have any application (sybase / informex) not oracle tools make it.
how to connect from this application on the oracle database??
thank you
hish
_
Get Your Private, Free E-mail from MSN Hotmail at http://ww
Try out this
Drop index U_SPYADH_2 ;
Regards
Magesh
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 5:50 PM
> Hi Gurus,
>
> I tried to drop unique index using "ALTER TABLE table_name DROP UNIQUE
> (column_n
It's not possible to solve any performance problems without CPU usage and
waits.
I recommend:
- get Event1006 trace file of your sqlloader session as defined at
http://www.unal-bilisim.com/products/itrprof/itrprof_user_manual.html#prepar
eTrace .
- run itrprof at http://www.unal-bilisim.com/produ
Okay fill us in why would you try and inane thing like that on only 128MB
RAM. NT would be barely running on that without getting your instance up. I
am not that good yet at calculating what amount of RAM you need for a given
SGA but I am thinking that you are running in swap
What is the disk
Testing what? Load performance? Data Integrity? Bank balance? Brain
capacity? User stupidity?
-Original Message-
Sent: Tuesday, May 29, 2001 10:02
To: Multiple recipients of list ORACLE-L
Hi List,
Anybody knows any model or tools for testing.
Thanks in advance
=
Hamid Alavi
4268
You CAN actually set the TNS_ADMIN variable in the registry under
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ - It may not be there at first, all you
need to do is create a new "key" called TNS_ADMIN with a value of the path
to your master tnsnames.ora file.
HTH
Mark
-Original Message-
Granaman
Hish,
Crack out some manuals double quick - get some RDBMS training, and learn a
little about what you are playing with here!
Sybase and Informix are not actually applications - they are Relational
Database Management Systems (RDBMSs) that are competitors to Oracle.
To answer the question thoug
All,
Just a quicky
!!
Anyone know if there
are any locking issues while analyzing statistics for objects
??
TIA
Lee
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the rea
mount the database in exclusive mode, do not open.
issue..
archive log start.
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 3:40 PM
> i guess you forgot to do
>
> svrmgrl> archive log start;
>
> > --
> > From:
Title: Number Vs. Varchar2 Datatype
this always a better decision to
decide the datatypes of such columns keeping in mind the future
requirements.
u may come to a certain point where
u think, number datatype to be better and somewhere to varchar2.
u said number datatype which is not
always
Suggestion given by Magesh should work for a non-constraint index. If it is
index created by Oracle during the time when you created your unique
constraint you won't be able to get rid of that index until you eliminate
your constraint.
- Original Message -
To: "Multiple recipients of lis
That's a laugh, I went to a continuing education seminar once at Carleton
University, in Ottawa.
The seminar was called Effective Living.
The teacher was a social worker, and he emphatically told everyone NEVER to
ask why, just adapt to life and keep moving...
I had unreconcilable disagreements
Hi,
Did you try :
SQL> drop index index_name ;
??
HIH,
Antonio Belloni
"CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>@fatcity.com on
30/05/2001 05:50:25
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Quick question..
ALL of my experience has been on UNIX platforms... Recently, I have been
asked to work on an Oracle DB that runs on NT.. My scripting capability in
the NT world is "weak" at best. So I am trying to compare ksh type
activities with the NT world. SO I was wondering if any of you w
When you use privileges in stored procedures, you need to have the privilege
explicitly. In other words, you cannot get the privilege from a role.
If you do a grant create user to MyRole.
Grant myRole to myUser.
Then try to create user as myUser it will work, but if you try to create
user from
I have built Novell boxes that have 2100+ days of uptime :)
Now that is stability that I have yet to see even unix have.
Granted it is only Novell 3.12.
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
--
Yes,
table is exclusively locked when ANALYZE ... VALIDATE. Until 9i, I
believe.
Vadim
Gorbounov
Oracle
DBA
-Original Message-From: Robertson Lee - lerobe
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 30, 2001 7:22
AMTo: Multiple recipients of list ORACLE-LSubject:
Analy
There isn't any known bug under NT. But there are many memory leaks and
poor drivers, that tend to lead to early rebooting. In my experience.
I think the worst problem with NT is not the os but the drivers, even though
Even though I hate NT, for the money, it works well. But if you try to get
just my input.
where are the load metrics documented, meaning where does it say 5M or more
per session? i want to know for future reference.
we're putting in a solution, oracle 8i on windows 2000/windows 2000 advanced
server ~4-to-8G of RAM so there are options if you need additional RAM in
exc
Hi Lee,
Compute option locks a table, but 'estimate' doesn't
Regards,
Ed
-Original Message-
Sent: 30 ??? 2001 ?. 15:22
To: Multiple recipients of list ORACLE-L
All,
Just a quicky !!
Anyone know if there are any locking issues while analyzing statistics for
objects ??
TIA
Lee
Ok, now I'm confused
One reply
-
It depends. For instance, 'analyze index validate structure' takes out
'shared' lock on the table (preventing inserts/deletes/updates), while
'analyze index compute/estimate statistics' does not.
Another
---
Compute option locks a tabl
If it is an unique index that enforces unique constraint you cannot simply
drop it
You have to drop unique constraint
alter table tablename drop constraint constraintname;
an example follows
SQL> desc qaqa1
NameNull?Type
--- ---
I think thats the reason why we have two options - Estimate and Compute Statistics.
Rajaram.
-Original Message-
From: Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 7:22 AM
To: Multiple recipients of list ORACLE-L
Subject:Analyze table and lo
shouldn't be any problems running apache on the same server. at least
i've set up oracle on solaris 7 with apache installed.
Jon Baker
Database Engineer (1/5)
<[EMAIL PROTECTED]>
Rukmini Devi wrote:
>
> Hi List,
>
> SunOS
In fact, the restriction on use of privileges granted via a role applies to
*all* stored objects (e.g., views), not just stored PL/SQL code.
Paul Baumgartel
[EMAIL PROTECTED]
917 549-4717
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday,
This person was actually allowed to teach. Never ask why, yes that's a
super philosophy on life.
-Original Message-
Patrice J
Sent: Wednesday, May 30, 2001 8:31 AM
To: Multiple recipients of list ORACLE-L
That's a laugh, I went to a continuing education seminar once at Carleton
Univers
Azhar,
I agree with the other responses (more RAM, don't use OPTIMAL on your
RBS's) but would also suggest dropping all indexes except PK until the load
is done, the rebuild them. Also, does this table have any
triggers? If so, if can you disable them during the load, that will help
spe
I would not recommend using optimal as it will cause the segment to have to
shrink. Your better of doing it manually on lulls of activity and size the
segments bigger if need be. Segments should not be frequently shrinking.
"Walking on water and developing software from a specification are ea
It depends.
For instance, 'analyze index validate structure' takes out
'shared' lock on the table (preventing inserts/deletes/updates), while 'analyze
index compute/estimate statistics' does not.
For more info see 'Practical Oracle 8i' by Jonathan Lewis -
very good book.
Igor Neyman, OCP DB
This is totally NOT accurate.
Yes there are performance gains storing index data ordered. Perhaps great
on range scans. Yes you can reorder tables and indexes.
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspo
I am migrating data from one database[database1] to another[database2]. I
have a
link[dblink] between the two and one of the tables[CLOB_TABLE] have CLOB
datatype for one of their attributes[CLOB_BODY].
I need to cursor through this CLOB_TABLE and then insert the cursor variable
values into databa
Title: Number Vs. Varchar2 Datatype
VARCHAR2 is more efficient marginally for sorting and indexing.
Oracle
claims numeric primary key is faster, but there has been proof
otherwise.
But if
your data is number, it should be stored as a number. The speed difference
is very marginal.
"W
Title: RE: Creating a sorted table
That
is version specific, but you can use an index hint to do this in older
versions.
"Walking on water and developing software from a
specification are easy if both are frozen."
Christopher R. Spence Oracle DBA Fuelspot
-Original Message-From
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 30th June 2001.
Peter McLarty wrote
"Are you running RAID
Uptime yes... BUT was there anything running on them as complex as a database?
Just joking. I have used Novell in the past ver 2.something and it served the purpose
very well. At my current work location we use 4.12 and it is okay at best. Upgrading
to 5.1 this year before we install a financia
Created a sandbox database using Database Administration utiltity, (8i Rel
3, PE, NT4). I ran full export of a database. I then used the imp utility
with indexfile parameter to create the DDL for the database. I expected to
be able to find the DDL for the tablespaces TOOLS, USERS and some other
When I build a new test database I create the database and run all the
required Oracle scripts. Then I do a full import of a production export.
This works pretty well but I miss some of the grants and The full import
wants to create tablespaces that I may or may not want created. I get a lot
of
that's not dropping a unique index, that's dropping a column!
to drop an index:
drop index ;
doesn't matter if it is unique or not.
If you are trying to drop a unique constraint, that's different.
first find the name of the unique constraint on that table"
select constraint_name from user_c
On Wed, May 30, 2001 at 05:01:22AM -0800, Christopher Spence wrote:
> I have built Novell boxes that have 2100+ days of uptime :)
>
> Now that is stability that I have yet to see even unix have.
> Granted it is only Novell 3.12.
Novell uptime:
http://www.theregister.co.uk/content/5/18265.html
=
I agree. Is your Shared_pool_size set to 239MB? You can't ask Oracle to
allocate this much memory with excessive swapping on your NT box. If you
can't add mode RAM, I would cut that to around 50 MB. I would also do what
Peter recommends below. There are always a few more things to try (like
direct
Actually we have to
Since Data is being loaded in development environment. that is why we have
128 meg ram. (Regarding RAM i have no other choice) i have the NT
performance monitor and it shows that it is not using swap heavily.
Currently disk configuration is not RAID . however we have no di
Analyze index validate structure takes shared lock on the table disallowing any changes to the table or indexes. That's the only way to validate the structures.
In earlier versions (7.3 ?) 'analyze ..compute' used to take table level locks. From 8 onwards, compute or estimate does not take any ta
Peter is right. Look at your SGA it's 285M. If you only have 128M on
the machine you are running your at least 75% of your db in swap. I
would recommend 512M MINIMUM on this system push for more if you can.
RAM is relatively cheap right now for intel machines get some. After
that you need
Azhar,
Just two thoughts off the top of my head to improve loading of records:
1. Put database in noarchivelog mode to avoid redo generation (if
possible).
2. Drop all indexes on target tables (if possible), then load data, then
recreate all indexes on target tables.
Jim
Jim Hawkins
Lead SA
If you every try and knock a cat off of something when she really
does not want to go you will see that quite clearly. It really is quite
amazing (and annoying).
-Original Message-
Sent: Tuesday, May 29, 2001 7:12 PM
To: Multiple recipients of list ORACLE-L
\ ?
Eric,
duct tape not nee
Yeah If you use compute statistics your table get locked and will take long
time, But If you use estimate statistics it will be fast But not as
accurate as before. Better to analyze at nights by setting time.
Raghu.
>From: Robertson Lee - lerobe <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTE
Hi Bruce
As I understand ur server uptime is 242 days.Right!If this is the case then
Please reboot the server would solve this problem.The similar kind of
problem I faced in past.
Hope this will help u.If you would like to more information then please
visit metalink.
Thanks
-Seema
>From: Raymo
Why putting DB in noarchivelog will avoid redo generation? There will be no
archiving, but redo will continue to be generated.
Alex Hillman
-Original Message-
Sent: Wednesday, May 30, 2001 10:21 AM
To: Multiple recipients of list ORACLE-L
Azhar,
Just two thoughts off the top of my hea
Ya, but I can keep a NT box for a long time to, if I don't touch it.
-Original Message-
Sent: Wednesday, May 30, 2001 6:01 AM
To: Multiple recipients of list ORACLE-L
I have built Novell boxes that have 2100+ days of uptime :)
Now that is stability that I have yet to see even unix hav
Diana,
You might wanna check out www.kx.com Those guys have
a lightning rocket of a dbms, and it is based, in part,
on storing data in search/sort-dependent order. (There is
a bunch of background data on the site itself.)
In any case, reading up on other dbms technologies has
a place in any
Six years? No downtime in any way? That would be...uh.unusual.
I am sure the details are fascinating...do tell.
|| -Original Message-
|| From: Christopher Spence [mailto:[EMAIL PROTECTED]]
|| Sent: Wednesday, May 30, 2001 9:01 AM
|| To: Multiple recipients of list ORACLE-L
|| Su
Are you trying to find maximum size of the IO possible in Sun/Solaris ?
Kernel parameter maxphys parameter determines the maximum size of the IO
possible from the OS. By default, it is around 128k depending upon what
hardware you use(sun4d=124k, sun4u=128ketc ). If you user veritas volume
manag
Not necessarily. 8i+ DOESN'T require _ANY_ lock to COMPUTE while collecting
statistics (99.99% of total operation time). It needs short lock to start
and complete analyze.
Regards
Vadim
-Original Message-
Sent: Wednesday, May 30, 2001 9:07 AM
To: Multiple recipients of list ORACLE-L
Hi
On NT 4 with Developer 6i and Oracle 816/817 I have never been able to get
Oracle db to work off of the tns_admin key. Only forms would work off of
the tns_admin, and without that key forms would not connect to the dbs.
Just thought I would mention that.
Kev
-Original Message-
Sent: Wedn
On 30 May 2001, at 8:10, Christopher Spence wrote:
> This is totally NOT accurate.
http://www.amazon.com/exec/obidos/ASIN/B5BYQH
---excerpt---
Tales of the Arabian Nights Barbie and Ken
Our Price: $99.99
This item will be rele
mainekoon cats. Almost as big as dogs, and do pull sleds.
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Wednesday, May 30, 2001 1:21 AM
To: Multiple recipients of list O
Reminds me of a bad joke...
What did the farmer say when his tractor broke?
-Original Message-
Sent: Wednesday, May 30, 2001 12:03 PM
To: Kevin Kostyszyn; [EMAIL PROTECTED]
Just because!
Reply Separator
Author: "Kevin Kostyszyn" <[EMAIL PROTECTE
John, have you read Cary Millsap's paper on RAID 5? www.hotsos.com I
believe. RAID 5 will require additional writes by DBWR which is going to be
huge overhead during a dataload.
- Ethan Post
-Original Message-
Sent: Wednesday, May 30, 2001 6:51 AM
To: Multiple recipients of list ORACLE-
Hey, NT could be up for 2100+ days, I mean, by the time you get there it
won't even be able to play solitaire, but it will be up.
-Original Message-
Spence
Sent: Wednesday, May 30, 2001 9:01 AM
To: Multiple recipients of list ORACLE-L
I have built Novell boxes that have 2100+ days of up
http://www.ultratech-llc.com/KB/Scripts/?File=Scripting.BAT
(also see bottom of this message for more URLs)
http://www.ultratech-llc.com/KB/?File=!Contents.TXT
--forwarded message follows--
[Date sent: Wed, 30 May 2001 10:32:11 -0400
To: Recipients of WINNT-L digests <[EMAIL P
Well, depending on the size of the db and some other network stuff, I do the
following. I shut down the real db, copy all of the data files,
controlfiles and init file to a machine with Oracle on it. Then you can
create the service (NT), alter any of the datafiles if necessary (on
different logi
Yeah, I'd say that proportion would have worked in my group too.
And when I interviewed others, I rarely got any great people
applying, and it's almost solely because at that level, dollars
were so much better as independents, and the only people who
wanted to come were visa-sponsors or relative n
On Wed, 30 May 2001,Christopher Spence scribbled on the wall in glitter crayon:
->mainekoon cats. Almost as big as dogs, and do pull sleds.
and like laps. and if you don't make one for them, they just tangle your feet
till you fall down and then climb in your lap.;-)
--
Bill Thater
Many
thanks
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: 30 May 2001
17:10To: Multiple recipients of list ORACLE-LSubject:
RE: Analyze table and lockingAnalyze index validate structure takes shared lock on the table
disallowing any changes to
I'm going to retract part of this post, as it has been pointed out
to me that 7.3 on NT normally consumes about 1.5 meg of
RAM per session. This is of course dependent on SORT_AREA_SIZE.
I've obviously disremembered common memory usage stats
for 7.3.x. That and a lot of my 7.3 experience in on
If under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE you have one or multiple
folders, like:
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME1
then you have to create TNS_ADMIN string value (not key) in each of those
folders pointing to your master tnsnames.ora file.
We have Enterprise Edition 8.1.7.1 on Sun Solaris 2.6.
My manager needs a definitive answer. Is DBMS_OBFUSCATION
free with this version of Enterprise Edition server or is it part of an
extra-cost add-on.
All definitive answers welcome. I have a call in to Oracle but they
have not yet responde
Hi all
Can someone help me out here? I am getting this error when I try to run this
PL/SQL code from an ASP page.
The error manual just says to check speeling. I DID. Is there anything I am
missing? The DB is V7.3 I am trying to
return the resultset to the page.
PLS-00306: wrong number or type
On Wednesday 30 May 2001 03:10, Saurabh Sharma wrote:
>
> should i give it all four arguments. but it still not executing saying
> ora-06512
There are always other error messages accompanying an ORA-6512.
What are they?
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
A
Its not a general Oracle or Unix thing because we had out AIX boxes up and
running Oracle 7.3.4 and 8.1.6 for many months at a time with no reboots.
-Original Message-
Sent: Wednesday, May 30, 2001 9:50 AM
To: Multiple recipients of list ORACLE-L
Hi Bruce
As I understand ur server uptim
Actually I say:
"You know what the farmer said when the cow died?"
"Geesh, it never did that before."
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Wednesday, May 30, 2
I had the same problem. First, i realized that - it seems -
there are other things that will bump the PGA. For me it was
insert /*+ append */. However, after upgrading from 8.1.5 to
8.1.7 the problem went away.
Hope this helps, and your mileage may vary.
Good luck,
Yosi
> -Original Messag
Yeah, I think they've got a retention problem, since the money is
better outside, and consultants have a good idea of what they're
being billed for. But the internal resources are great, as are
their internal email lists.
Of course, now we've got much of their internal stuff on metalink -
if you
Ours is not to wonder why, ours is just to do or die!!
Reply Separator
Author: "Kevin Kostyszyn" <[EMAIL PROTECTED]>
Date: 5/30/2001 7:02 AM
This person was actually allowed to teach. Never ask why, yes that's a
super philosophy on life.
-Origi
My suggestion would be to install cygwin
(http://sources.redhat.com/cygwin/).
> -Original Message-
> From: GLoughmiller [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 30, 2001 8:25 AM
> To: ORACLE-L
> Cc: GLoughmiller
> Subject: Script examples for NT. (yuk!)
>
>
> Quick question..
Raid 5 can consume as much as 60% overhead for writes.
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Wednesday, May 30, 2001 12:51 PM
To: Multiple recipients of list ORAC
Try changing to VARCHAR2(31) instead of VARCHAR(31). Although I know there
is no difference in varchar and varchar2 definition.
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expresse
Isn't that sort of like Taoism? Accept your lot, there must be good in it
somewhere...
Also, it seems to be the basis of many major religions to essentially never
ask why. So, I guess it's a pretty popular philosophy.
(Oh no, I feel a discourse by Eric coming on...)
Diana Duncan
TITAN Techno
Sean,
The indexfile parameter shows only the create table
statements (REM'd out) and the additional indexes (i.e
not indexes used to enforce PK constraints).
To see all the DDL, use the SHOW=Y parameter along
with LOG=.
HTH,
-- Anita
--- "O'Neill, Sean" <[EMAIL PROTECTED]> wrote:
> Created a
I have used compute statistics since version 7.3.2 up through 8.1.6, and never
had it hold a table lock for the duration of the analyze. I don't know where
people are getting the idea that compute statistics holds a lock and estimate
doesn't. That just doesn't make sense. Why would compute need
DBAs,
As a keyboard lover, hate to do this. But I need to study OEM.
Any good Books / URLs / DOCs / PDFs
Thanks in advance,
-Rahul
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rahul Dandekar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
After upgrading from Enterprise Edition 7.3.4 to 8.1.7.1 on Sun Solaris
2.6, we are
having problems executing a procedure with CharArrayType as shown below.
We don't get any error message. The package simply does not return any rows
when there are rows out there that should be returned.
The dev
Yes..Cloning is bit mature than export and import.
BTW you don't need to have the same directoty tree in
the target database. You can have a differenet
directory tree ..(you can edit the control file script
and it is done..)
=
Have a nice day !!
-
Redo generation will not change. Just the archiving process, which on
improperly laid out file system can be very painful process.
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message---
I am using this parameter on 8.1.6.2 for the same bug: "1210242: CURSORS NOT
SHARED WHEN TIMED_STATISTICS=TRUE DESPITE FIX FOR BUG 918002."
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 29 May 2001, Jerry C wrote:
> Anybody have experience setting this parameter? It references a
Huh?
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Wednesday, May 30, 2001 1:26 PM
To: Multiple recipients of list ORACLE-L
sorted table
On 30 May 2001, at 8:10, Chris
Sure, and thanks. I appreciate the corrections, as one problem with doing
this for a while is the aggregation of useless and no longer true "facts",
which I'm finding I have more and more of. They feel like barnacles. :)
I've finally decided to go get my OCP, which I hope will help scrape som
Cherie, I have no idea if this could be the case, but I noticed that the
type is based on the datatype VARCHAR, not VARCHAR2. According to the
docs, this shouldn't make a difference, but they've been warning since the
introduction of VARCHAR2 that they may do something different with VARCHAR
at
Either MS ODBC or Oracle driver can do the connectivity. I found out that MS
ODBC is more user-friendly.
Just my $0.02.
-Original Message-
Sent: Wednesday, May 30, 2001 4:30 AM
To: Multiple recipients of list ORACLE-L
Hish,
Crack out some manuals double quick - get some RDBMS train
Indeses are not critical for the application to run..It just helps them run faster at
times. You could build you indexes with the "no logging" or "unrecoverable" option
and that will save on the archivelog creation. Just be sure to take a backup after the
indexes are rebuilt because you will n
1 - 100 of 249 matches
Mail list logo