>From the Intermedia New Features for 8.1.6
-
We now recommend processing pending DML through a dbms_job -- an
individual job for each index, a ctxsys job for all indexes, or some combination of
the two. This el
I don't even bother with the CD, I just copy the docs to my PC. Right
now I have 7.3.4/8.0.5/8.1.7 and 9i on the machine.
doesn't take much space and since when I travel the CD is external and
therefore "optional" for me to carry, I always have the docs when I'm
writing
--- Kimberly Smith <[EMA
well if it is owned by oracle then only oracle type jobs can be executed
by the (un)intelligent agent), if you needed to run a job that needed
privileges outside of oracle, it wont run, hence the reason it needed to
be owned and setuid of root.
is it a security risk, no doubt, would i run it
they do "set transaction "?? if so, yes, as the trigger is part of
the same transaction
--- Kevin Lange <[EMAIL PROTECTED]> wrote:
> Hey gang;
> If my developers use the large rollback segment to perform their
> updates
> to data, will any triggers firing on the affected tables also use
>
Kevin,
Look up the excellent presentation at http://www.evdbt.com/library.htm
on rollbacks. It's call "Cats, Dogs and ORA-01555". There's a
MS Word doc and a power point presentation.
Also look up rollbacks at Steve Adams site and Jonathan Lewis' site.
The short answer to your question is 'M
yeah I think he went from "you won't need a DBA" to "you will need lots
of DBAs to manage all the different specialized features" :)
--- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote:
> True:
>
> If you listened carefully to Larry at OOW, he backed off that
> statement,
> saying that the DB
Well, if root is suppose to own it then how come
when it was changed it to oracle it worked? I must
say, I never looked but I installed the 9i OEM and
did not run root.sh after and it still worked. Since
I don't have root access I don't see how it could be
owned by root. That was on HP. Just c
Gene:
I'm currently unable to download any of the ODBC drivers.
Seems like something's amiss at otn
barb
> --
> From: Gene Sais[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Friday, December 21, 2001 2:30 PM
> To: Multiple recipients of list ORACLE-
Title: How to backup MTS database with RMAN
Hey
gang;
If my developers use the large rollback segment to perform their updates to
data, will any triggers firing on the affected tables also use that rollback
segment ??
-Original Message-From: kevin wang
[mailto:[EMAIL PRO
Title: How to backup MTS database with RMAN
Hi, Hulmet,
I tried. To use RMAN on MTS database
environment, both database server machine and the RMAN machine(the machine you
run RMAN on it) should use dedicated server mode instead of shared mode. It
means the tnsnames.ora file on these two ma
because root is supposed to own it.
root.sh sets it, last i checked,
joe
Kimberly Smith wrote:
> How did root end up owning it???
>
> -Original Message-
> Sent: Friday, December 21, 2001 10:20 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Guys!!!
>
> I found the problem, you
Can anyone else download the odbc driver 8.1.7.5 from technet? It's been timing out
on me for days now.
Gene
PS. Enjoy your holiday whatever that may be!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
INET: [EMAIL PROTECTED]
Fat City Network Services
Joe Raube wrote:
> 1 - never create objects as SYS
> 2 - svrmgr is gone in 9i - stop using it
>
> I would drop all user objects that you created as SYS,
> and recreate using a DDL script.
>
> -Joe
Joe,
I would beg to differ on the use of svrmgrl over sqlplus in 8.1.x.
None other than Tom Kyt
This figure includes the shared memory portion of Oracle. The memory
usage per process can be determined by subtracting the size of the
shared memory segments for that instance.
'ipcs -ma' will display the shared memory segments and sizes.
Or you can use svrmgr to locate the correct segmemts:
Really?
Do you know which version?
In 8i it seems to be alive and well, and iFS requires it.
Maybe as of 9i?
Jared
"MacGregor,
How did root end up owning it???
-Original Message-
Sent: Friday, December 21, 2001 10:20 AM
To: Multiple recipients of list ORACLE-L
Guys!!!
I found the problem, you just needed to change the ownership of the dbsnmp
file from root to oracle, after that everything is working!!!
thanks
Jared,
Some places do have internet connections and email separated.
Fujitsu for one. Department of National Defense is another.
However, that being said, all Oracle CD box sets come with
at least one CD that contains documentation. I have 6 million
of them (roughly). I personally believe in k
Patrice,
I am not sure anout Tru64, but I believe these values include the SGA. Of
so, you will have to use something equivalent to 'pmem' in Solaris to
identify shared portions of SGA/executables and figure out the per session
requirement.
Merry Christmas and a Blessed New year!
John Kanagaraj
List,
I wish all of you a merry
christmas and happy new year. You guys are great help for the beginners,
like me.
Thanks all of you
!!!
Ramon E.
Estevez
[EMAIL PROTECTED]
Dominican Republic
809-565-3121
Ken,
SYS objects are NOT exported since an import of SYS would basically then
import database metadata. The only method is to create another schema (not
SYSTEM!) and move these tables into the new schema using a series of CTAS.
If you have the DDL scripts, then run them against the new user rathe
Ps -efl on Tru64 UNIX.
e.g.
88008001 R 9001 1931 1 19.2 44 0 149M -16:52:15
03:59:11 oraclesid (LOCAL=NO)
88008001 R 9001 10017 1 17.0 44 0 146M -10:19:45
04:36:09 oraclesid (LOCAL=NO)
88008001 R 9001 10732 1 16.9 44 0 144M -
Thanks for the reply
I have tried ctx_ddl.sync_index() but it can be used to synchronize
ctxsys.context indexes only. In my case it is ctxsys.ctxcat index.
Since it gets updated properly when I use few different ways to
insert records I believe it is something specific to the way
ADODB.Records
Ken,
You can use a tables= option to list all the tables you want exported. And
then use the fromuser= and touser= option to import them (to the right
tablespace).
Also, please remember that there is an upper limit on the number of
characters in the tables= list. I can't remember the exact numbe
Guys!!!
I found the problem, you just needed to change the ownership of the dbsnmp
file from root to oracle, after that everything is working!!!
thanks to the people who took of their time on this one.
Jose
At 06:05 AM 12/21/01 -0800, you wrote:
>Joe;
>
>I already tried that, I went to my l
Thanks Jared
I understood that ctxsrv affects the index of type ctxsys.context only
while the ctxsys.ctxcat gets updated with transactions but certainly
will do some more reading...
Witold
>
> My experience with intermedia or context server, or whatever
> they call it this week, is in deali
Is it just me, or is something wrong with this site?
I would love to see a copy of this paper. When I go to this url and click
on the "session search", I get an "error document 404".
Is there another way to get to the open world papers??
Thanks.
Barb
> --
> From: Post, Ethan[S
True:
If you listened carefully to Larry at OOW, he backed off that statement,
saying that the DBA is necessary to make sure that all of the Oracle9i
features are implemented properly.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobil
I believe you will need to CREATE OR REPLACE SNAPSHOT or drop and then
recreate it.
Before dropping it, look at the view DBA_SNAPSHOTS for the contents of the
snapshot. Secondly, you can, within SQL*Plus, type HELP SNAPSHOT, and get
some syntactical help with the commands. Otherwise, you will n
Ctxserv has been deprecated. Check the directory $ORACLE_HOME/ctx/sample/script for
the approved ways of keeping the indexes in synch.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, December 21, 2001 9:41 AM
To: Multiple recipients
Cherie,
There is a Table-to-entity Retrofit selection within the Entity Relationship
Diagrammer tool under the Utilities menu option.
I havn't used it recently, so can't speak for how well it works.
As for as I know, all of the user documentation is loaded when you install
the tool, and is avai
Your internet connection is down?
How are you reading this?
Jared
[EMAIL PROTECTED]
> oh, and of course, my personal favorite (this has been said since 7)
> "you won't need a DBA anymore"
And just who would hold the duhvelopers hands then?
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services
There were other problems which were masquerading as a refresh problem.
Merry Christmas and Happy New Year to all.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego
My experience with intermedia or context server, or whatever
they call it this week, is in dealing with iFS, so I know just
enough to be dangerous. :)
It sounds like you need to have the context server running
to periodically update the indexes.
On unix it's 'ctxsrv'. I suggest you read the
Patrice,
How are you determining that a session is require 140M?
This number may be misleading.
Jared
"Boivin, Patrice
Oracle 8.1.6.0
We're trying to recreate our snapshots. We used the syntax 'CREATE
SNAPSHOT'. The snapshots won't refresh. Error message is ORA-12018.
Everyone's gone for Christmas with their office's locked (documentation
inside!) and the internet connection is down. So 'R'ing TFM is out of
If you move with FULL=Y, you will move the entire database. Because you
have placed objects in SYS, in violation of general DBA guidelines, you have
forced this upon yourself.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248)
We have an existing Server Model within Designer/6i.
Is there an easy way to reverse engineer an entity model
from the server model?
I am looking at OTN and can't figure out where the Designer/6i
users guides, etc. are. All I can find are the installation guide,
Configuration guide, migration
Mount the file system that holds your temporary tablespace in Direct mode
(non-buffered mode) and try to find if AIX has something similar to the
priority paging in Solaris.
Also Raw partitions are good at least (in your case) for temporary
tablespace.
Also check if your tablespace is defined a
and svrmgr was going in 8i too... took them until 9i
oh, and of course, my personal favorite (this has been said since 7)
"you won't need a DBA anymore"
--- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote:
> Everyone needs to remember that the Oracle Import Utility is just a
> 3GL "C"
> program
1 - never create objects as SYS
2 - svrmgr is gone in 9i - stop using it
I would drop all user objects that you created as SYS,
and recreate using a DDL script.
-Joe
At 06:55 AM 12/21/01 -0800, you wrote:
>I can't find any details of this in any of my documentation. I originally
>created my DB
export the tables and import them to the new user
--- Ken Janusz <[EMAIL PROTECTED]> wrote:
> I can't find any details of this in any of my documentation. I
> originally
> created my DB as SYS. I have setup a new user and need to move my DB
> /
> Tables, etc. to the new schema. How do I go ab
What about moving all the tables at one time (FULL=Y)? I have about 150
just for the application. And another bunch for the DB.
-Original Message-
Sent: Friday, December 21, 2001 9:45 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Move DB to Another Schema
Ken
Everyone needs to remember that the Oracle Import Utility is just a 3GL "C"
program with INSERT statements. It is widely publicized that the ratio is
1:4 so this should not come as a surprise to anyone. Some ways to improve
performance is to use a large buffer size (10-20M) and set COMMIT=Y to
f
Ken,
Get rid of the SYS-owned tables that you created, and create a new
tablespace, under which you can create your schema's objects. Do not try and
export/import. Those tables have no business being in SYS tablespace.
Carefully, drop them.
Thank you,
Paul Sherman
DBA
voice - 781-501-4143 (off
Ken,
Do a full export as user sys.Then create a new userid to act as the
owner of those non-sys and non-system tables.
Do an alter user owner_of_tables default tablespace
tablespace_for_application_tables;
Do an import of the application tables using the table (or tables - I can't
remember)
Ken Janusz wrote:
>
> I can't find any details of this in any of my documentation. I originally
> created my DB as SYS. I have setup a new user and need to move my DB /
> Tables, etc. to the new schema. How do I go about this? Can I do it via
> SQL Plus or do I need to do it via svrmgr? Or,
Ken.
After creating the user, you can use export to move the tables one at a
time. You will need to specify the owner of the table on the export (ie:
SYS.table name) and then on the import you will say FROMUSER=SYS TOUSER=xxx
on the command line. I would suggest examining the Utilities guide
well, yeah, depending on the number of indexes, I've seen a 6 hour
export take almost 24 hours to import -- on the same box as the export
was done.
I was trying not to frighten anyone :)
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> Rachel Carmichael wrote:
> >
> > in addition, define what
-- "Bunyamin K. Karadeniz" <[EMAIL PROTECTED]>
> Does anybody know any websites of Germany or England related with Oracle
> jobs ?
Try dice.com w/ internatinal jobs.
--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
This
has been the documented behavior for non-LMT
for
quite a while. From the storage clause section
of the
SQL Reference Manual
"Oracle
rounds
values up to the next
multiple of the data block size for values less than 5 data blocks, and
rounds up to the next
multiple of 5 data block
Hello
It may be little OT but I am sure there are developers here. Also I
hope some DBAs may know the answer...
I am experimenting with Oracle Text - need to use the field from a
VB application.
I have a table with a CLOB column and a ctxcat index built on that
column. If I insert records us
I can't find any details of this in any of my documentation. I originally
created my DB as SYS. I have setup a new user and need to move my DB /
Tables, etc. to the new schema. How do I go about this? Can I do it via
SQL Plus or do I need to do it via svrmgr? Or, would it just be easier to
cr
> Oracle 8.1.7 on AIX.
> Our database is rapidly expanding. Now it's approximately 80GB and for few
> months it's going to be at least double of that size. We are planning some
> reorganizations, so I'm wondering could you give me some advice.
> Is it better to have several big file systems or l
Joe;
I already tried that, I went to my linux server, I installed the OMS, it's
up and working, I discovered the node and the database, the agent dsnmp is
working, I am logon as oracle, I created an account under the same name,
with all the rights and roles available, I have the credentials se
Thanks for all the help I received, especially as this was my first posting.
LMTs are now a separate, and definitely, tested, project for the future.
>From us here in Edinburgh, Scotland, have a peaceful Christmas and a
memorable Hogmany!
Heather
--
Please see the official ORACLE-L FAQ: http
There are some hints and tips about import speed on my
site (see sig) - a little out of date but still mostly
relevant.
hth
connor
--- Ruth Gramolini <[EMAIL PROTECTED]>
wrote: > You can't do much. I have two tables
importing as I
> write that have been
> running since 2:30 yesterday afternoo
Rachel Carmichael wrote:
>
> in addition, define what you mean by "much time" -- how much data are
> you loading? how slow is the load actually? I've found that in
> general, an import takes about twice as long as the export.
>
Rachel, I don't know it's because of the festive season but I find
Thanks for all the help I received, especially as this was my first posting.
LMTs are now a separate, and definitely, tested, project for the future.
>From us here in Edinburgh, Scotland, have a peaceful Christmas and a
memorable Hogmany!
Heather
--
Please see the official ORACLE-L FAQ: http
Hamid,
Change your trigger as follows:
Create or replace trigger cre_PK
before insert
declare
loc_seq number;
begin
select seqname.nextval into loc_seq from dual;
insert into tableA(col1) values(loc_seq)
end
/
Hope this helps
Tom Mercadante
Oracle Certified Professional
-Origina
Hello Folks,
I have installed oracle 8i client on a windows 98 system and am
using an application that has the database in an NT server.
At some point of testing the application i get the error message
" caused an invalid page fault in module ORACLIENT8.DLL
at "
and the system (my windows 98 m
You can't do much. I have two tables importing as I write that have been
running since 2:30 yesterday afternoon and it is 7:00 in the AM. They have
16million rows each. But they have to put the rows in one row at a time.
And I am importing them into a bigger, faster, better box,
Ruth
- Ori
instead of stripping the other files from the controlfile, have you
tried to use the original controlfile, mount the database and then
offline drop the datafiles of the tablespaces you don't care about
before you open the database?
--- [EMAIL PROTECTED] wrote:
> OK we had some data deleted
in addition, define what you mean by "much time" -- how much data are
you loading? how slow is the load actually? I've found that in
general, an import takes about twice as long as the export.
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> Seema Singh wrote:
> >
> > Hi
> > Import is taking
Wish u the same and everyone & their family in the list a happy xmas and new year.
Venkat
--
On Fri, 21 Dec 2001 01:55:22
SARKAR, Samir wrote:
>Hi everybody on the list !!
>
>Am going on my holidays today evening and shall b back in the New Year.
>
>Wish you all a merry and drunk (for some) Ch
Does anybody know any websites of
Germany or England related with Oracle jobs ?
Hi all!I have created tablespace where initial and
next extents are same = 128KB.Block size is 4K.After creating test
table and querying DBA_SEGMENTS, I see that new tableoccupies 35 blocks,
instead of 32 blocks.Same happened with tablespace where initial = next
= 256 and test tableoccupied 6
Hi,
Some of our developers are using the Web Development Toolkit, and we now
find that some sessions from the web site require 140M of memory or more.
This is placing a strain on the backend server, memory usage for sessions
adds up quickly.
Is it normal for Web Toolkit connections to use up th
Hello Folks,
I have installed oracle 8i client on a windows 98 system and am using an
application that has the database in an NT server.
At some point of testing the application i get the error message
" caused an invalid page fault in module ORACLIENT8.DLL at
"
and the system (my windows 98 mac
All,
As I did the
Christmas shift last year, I am off on my hols until January 2nd. No on call
even.
To all have a safe,
happy and healthy Christmas and 2002. May we all look forward hopefully to a
more united and secure world next year.
Best Wishes from th
UK
Lee
Off to post my
n
Mark.u have to send the mail to [EMAIL PROTECTED] with the message
SET ORACLE-L NOMAIL to temporarily suspend mail from the list.
Samir
Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 95 76217
EPABX : +44
SET ORACLE_L NOMAIL
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Blum, Marc
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-
Personally speaking I think that it is one of the best books available on
Backup and Recovery.the case studies at the end of the boom r pure gems.
I have the Oracle 8 edition and the concepts r very clearly explained esp.
Media Recovery the concepts of which r still not very clear to many DBAs
Hi everybody on the list !!
Am going on my holidays today evening and shall b back in the New Year.
Wish you all a merry and drunk (for some) Christmas and a very happy and
database problem-free New Year !!
Samir
Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : [EMAIL PROTECTED
Personally speaking I think that it is one of the best books available on
Backup and Recovery.the case studies at the end of the boom r pure gems.
I have the Oracle 8 edition and the concepts r very clearly explained esp.
Media Recovery the concepts of which r still not very clear to many DBAs
Seema Singh wrote:
>
> Hi
> Import is taking much time.How to eliminate that?
> Thanks
> -seema
>
Check the paper by Paul Baumgartel in the library section of
www.oriole.com
--
Regards,
Stephane Faroult
Oriole Ltd
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ste
Hi
Import is taking much time.How to eliminate that?
Thanks
-seema
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
I
77 matches
Mail list logo
