Get the purge package written by Tim Gorman available from
http://www.evdbt.com/tools.htm (no 31 on the list)
Install it as user perfstat and then create the folloiwng 2 dbms_jobs as user perfstat
to take snapshots every hour and purge snapshot data older than 7 days
Works on 8.1.7 9 (but not
A good response Arup, gave me food for thought, now for some food for my stomach!
Thanks
John
-Original Message-
Sent: 01 September 2003 18:14
To: Multiple recipients of list ORACLE-L
It's hardly illogical. The purpose of this view is not to provide the SID of
the current session, but
Enable Network Tracing and check.
GovindanK
I'm confused, has anyone ever seen something like this before?
This query works as you can see:
select count(*)
from [EMAIL PROTECTED];
COUNT(*)
--
275375
We execute the following DDL:
DROP SYNONYM
Arup,Indy, List
Some
Clarifications please
If the Primary
Database is in ARCHIVELOG Mode (Physical Standby) archived files there from
are being shipped applied to the Standby Database, What is the need to
run the Standby Database in ARCHIVELOG Mode?
Are you implying 9i
My feeling is that, given the clumsy way external procedures are implemented, the
argument of C speed doesn't hold too well. If you must write a function which will be
called through IPCs each time you return a row, from instance, C will look javaish in
speed. Add to this that static variables
Thank you very mutch for your replys,
Today I finally found the problem. The traceroute shows the good route,
but a Ms Proxy Client installed on the server blocked the request
apparently. Just disabling it resolve everything.
Damien
Damien wrote:
I have to do netstat -a on the webserver or
Hi all,
is anyone using Net App Filer -products with Oracle environment.
What do you think?
Advantages
Disadvantages
Thank you for your time
gWant to chat instantly with your online friends? Get the FREE Yahoo!
Messenger
Hi,
You can query the v$session_wait (or event 10046 if you are a big fan of
10046)
to get the latch#. If I Remeber right the P2 value in the session wait
(or p3?) gives the latch number and you can join this with v$latch_name to
get the
name of the latch. Once you find out the waiting (or
- Original Message -
dollar cost of that. I remind you folks that Oracle is a for profit venture.
It's not Oracle's responsibility to make anything affordable. It's the
responsibility of Oracle to generate revenue, it is the expectation of
Oracle shareholders (of which I am one)
- Original Message -
It's too bad. It seems like it would be fun.
What for? Make the employer shell out another BIG bunch of notes?
To get a piece of paper that says on that date and with that hardware
one could perform a backup and a restore?
What does that say about the
On our production database there is the ability for the users to query
the database with some long running, date intensive queries. We came up
with a method of having the user kill is't own process if needed.
We user roles to allow the users acces to the data. Granted select on
V_$MYSTAT AND
OCM is about marketing. consulting companies will use that to sell their consultants.
Ive noticed that alot of employers and co-workers are more likely to listen to someone
who is certified than someone who isnt. Its one of the reasons, Im getting mine. Makes
it easier to get people to do what
I have a certificate suitable for framing that states that I am a
Database Administrator Oracle 7 Oracle Master. Does this new Oracle
Master negate my current Oracle Master certification? Is there and
upgrade path available? Does it really matter? Every thing that I have
accomplished I have done
Damien
Your gesture is appreciated. It is a must that such solutions are shared
with the list members.
GovindanK
Thank you very mutch for your replys,
Today I finally found the problem. The traceroute shows the good route,
but a Ms Proxy Client installed on the server blocked the request
- Original Message -
It doesn't work in only one direction. While jobs are bieng lost to cheaper
labor markets, Indian companies now have to compete with frighteningly
efficient
giants like Nike, Coca Cola, IBM, Microsoft, GM, Union Carbide and others.
On IT? I thought we were
Gunnar Berglund [mailto:[EMAIL PROTECTED] on Friday, September
05, 2003 5:24 AM said;
is anyone using Net App Filer -products with Oracle environment.
Yup. Hosts a horde of databases for a medium sized outfit - pehaps 3000
employees, 24/7 manufacturing.
What do you think?
I like it but I'm
- Original Message -
Degree/OCP achievement doesn't teach f all - in my opinion - though it
does prove your memory isn't shot.
I can think of much cheaper and much more reliable and credible ways of
checking my memory... :)
lot. The reason, for example, that I personally prefer
Hello:
I was wondering if anyone knew of a source that listed what each of the
scripts in RDBMS (catproc, etc) functionality.
So far I have only been able to find a small listing (10 common scripts),
and was hoping someone might have a more complete list.
I know that they are different version to
Earlier post did not reach. Hence Reposting.
Take a look at the Metalink Note:125149.1
ALERT: ONLINE Index Rebuild or IOT Table Move can Produce Corrupt Index
As per the note it affects 8.1.(5/6/7).x
It has the relevant info.
Also take a look at the Docid: 287936.999.
HTH
GovindanK
Well, you could find a job in Canada, no?
Can you find one in India too? I don't think so.
So it's not business as usual.
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
When working at International Air Transport Association (IATA), the company
moved around 60 jobs from Geneva
I'd love to see what you
come up with on this one. [EMAIL PROTECTED] 9/4/2003
11:59:31 AM
During my free time(ha, between developing pages for kid's soccer
association, redcross instructor and board member, family, work), are
you all interested in my discoveries when i start trudging thru
HI all,
I'm getting the following error when using temporary tablespace on a locally managed system tablespace. Seems if my system tablespace is locally managed I can not create a dictionary managed tablespace.
Can anyone let me know if it is a bad idea to have system tablespace locally managed
By business as usual, I meant that executives always try to save money and
will always do.
Now, IT is targeted. And pepople in IT find that very difficult because the
pay has been very good since 5-7 years and most people thought it would last
forever. Now it's time to wake up and see that IT is
15 minutes !
All our production db are set up at 1 hour interval.
A summary of the stats are centralized in 1 db and we keep that 2 months.
We go down to 10-15 minues to investigate problems.
I find a 15 minutes interval very short.
Thanks for the link to yapppack. We do a similar thing using a
Yes. Even with TIMED_STATISTICS=TRUE, relying on *any* statistic with
system-wide scope can waste your time. For a 34-page introduction to the
rationale behind this proposition, see:
http://www.oreilly.com/catalog/optoraclep/chapter/ch01.pdf
Cary Millsap
Hotsos Enterprises, Ltd.
Try creating the synonym as a public synonym. That will give everyone
privileges to it without granting them explicitly.
Ruth
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
GovindanK
Sent: Friday, September 05, 2003 4:10 AM
To: Multiple recipients of
- Original Message -
forever. Now it's time to wake up and see that IT is becoming a job like
another where you most hold to your job instead of going to job interview
just for fun.
A lot of people don't believe this when I say it, but when I started in
IT in 1975 what we got now
you can't have any dictionary managed tablespaces that are open for write
operations... dictionary managed read only tablespaces will still
work.
I think you're right, temp isn't being freed up... or is something else
using it, or is the index creation just that huge?
April Wells Oracle
I thought that Oracle datafiles over NFS was neither recommended nor
supported. Has this changed?
Rich
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
From: Brian Dunbar
Thanks,
Yes I have 200,000 millions row table ... I belive my tempoary tablespace is way too small.
-lizzApril Wells [EMAIL PROTECTED] wrote:
you can't have any dictionary managed tablespaces that are open for write operations... dictionary managed read only tablespaces will still work.
I
Hi,
There
are a couple of issues here. Firstly you need to know that when you get the
error about the "temp" segment when building the index, the segment in question
is the index. It is just that when building the index Oracle creates a temp
segment to sort the data in and to create the
We use the net apps for a number of instances as well. I'm would not
recommend them for an IO intensive application. If you are using a 100
Mb connection your max aggregate throughput will be about 6MB per
second, which is very bad. Try performing backups over this. If you do
use them, gigabit
http://www.smh.com.au/articles/2003/09/04/1062548967124.html
A - This is social engineering at its finest.
B - There is no security without PHYSICAL security
C - If you don't check up on your outsourcer, then you can apparently
get the shirt stolen off your back...
v/r
Stephen S. Wolfe,
NetApp Filer is a special case of NFS and is, in fact, supported by
Oracle
--- Jesse, Rich [EMAIL PROTECTED] wrote:
I thought that Oracle datafiles over NFS was neither recommended nor
supported. Has this changed?
Rich
Rich Jesse System/Database Administrator
Jay
Here is your chance to join the big league and become an expert in your
own area. One thing I've noticed in tracing the scripts is that many of the
scripts call each other. Something like catproc must call dozens of the
other scripts. Not that much need to understand every low-level
Hi List,
Could you please help me to get the source code of
the trigger without using any third party tools?
Thanks in advance,
Raj
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the
Daniel
That was close to my experience. Very useful for test databases where
throughput isn't that important. We find it very useful to clone 100-gig
production databases so the users have a complete data set to perform
staging tests. The NetApp provides a lot of inexpensive storage. But I
Title: Message
You
can always try DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL. I've never tried
it,
it
might be buggy, but in theory, the procedure would go like
this:
1)
Create locally managed tablespace
2)
Read the manual/
3)
Migrate the tablespace local - dictionary.
4)
Start
User_source or DBA_source for procedures and USER_TRIGGERS or DBA_TRIGGERS for
triggers.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, September 05, 2003 11:35 AM
To: Multiple recipients of list ORACLE-L
third party tools?
Hi List,
Could you
Title: RE: RE: URGENT : sql*loader performance problem on partionned tab
here the trace :
SELECT STATEMENT, GOAL = CHOOSE 2 72 1368
FOR UPDATE
FILTER
PARTITION RANGE SINGLE
TABLE ACCESS BY LOCAL INDEX ROWID FICOM HREL_FUSION 2 72 1368
INDEX RANGE SCAN FICOM
Two IBM mainframes stolen? Boy, the times are changing! To steal only a
single 3090 600J,
one would need a whole infantry division, not just two guys with a dolly.
I bet they'll end up running Linux and having a ton of Jared's perl scripts
on them.
--
Mladen Gogala
Oracle DBA
-Original
set long 32656
col trigger_body for a80 word
select trigger_body from dba_triggers where owner='xxx' and trigger_name =
'yyy';
At 07:34 AM 9/5/2003 -0800, you wrote:
Hi List,
Could you please help me to get the source code of
the trigger without using any third party tools?
Thanks in advance,
Vivek,
The origianl poster inquired on Physical Standby
(in 8i and 9i) as opposed to logical standby (only in 9i).
In physical standby, you don't have a choice of
running the standby in noarchivelog mode. The control file is created from the
primary as "standby controlfile" which is then
You can use view all_triggers or user_triggers to get the entire text. trigger_body has the trigger text. triggering_event, trigger_type , REFERENCING_NAMES etc have other details. You can also use enterprise manager to get it. One trick in enterprise manager is to add some spaces somewhere (a non
Well, the idea of extracting it from user_triggers or dba_triggers is a
little far fetched
and unnatural, but should work.
--
Mladen Gogala
Oracle DBA
-Original Message-
Oracle DBA
Sent: Friday, September 05, 2003 11:35 AM
To: Multiple recipients of list ORACLE-L
party tools?
Hi
I have TAKEN THE PLUNGE and using it for PRODUCTION...
ENRON used for all their production databases (100+ ) and they were several
hundred gig.
We are using a special Disaster recovery product of Netapps as well.
Brian
-Original Message-
Sent: Friday, September 05, 2003 11:39 AM
To:
Why is it far fetched and unnatural ? In my view that is the only way to
be sure to get the correct source.
At 08:09 AM 9/5/2003 -0800, you wrote:
Well, the idea of extracting it from user_triggers or dba_triggers is a
little far fetched
and unnatural, but should work.
Wolfgang Breitling
Mladen,
It's not buggy - I have used it without any side effects on 8.1.6 and 8.1.7. Works as advertised - for a change !
Srini Chavali
Oracle DBA
Cummins Inc
Mladen Gogala [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/05/2003 10:34 AM
Please respond to ORACLE-L
To:Multiple
That is a misconception - you do not reduce bidirectional traffic because
you are still reading/writing from the Filer.
However, you are mostly like to be seeing the effects of the different
levels of caching on the Filer itself, which translates through to a better
performance from your
Select from DBA/ALL/USER_SOURCE; if the source code looks
like a bunch of garbage, then it means the source code has
been wrapped, which is Oracle's facility of obfuscate it
so that you can't read it.
-Original Message-
Sent: Friday, September 05, 2003 11:35 AM
To: Multiple recipients
Just kidding.
--
Mladen Gogala
Oracle DBA
-Original Message-
Wolfgang Breitling
Sent: Friday, September 05, 2003 12:34 PM
To: Multiple recipients of list ORACLE-L
Why is it far fetched and unnatural ? In my view that is the only way to
be sure to get the correct source.
At 08:09
Title: Message
12913, 0, "Cannot create
dictionary managed tablespace"// *Cause: Attemp to create dictionary managed
tablespace in database//
which has system tablespace as locally managed// *Action: Create a locally
managed tablespace.
It's a
feature, not a bug. Why would anyone want
You can ofcourse use enterprise manager. You would have to get the body and other things like triggering event etc.
To use the "Show SQL"option : one trick to use is a space some place (basically non-change)and hit "Show SQL". That should give you the whole trigger sql. Good luck.
* Jared : I
Very insightful and I agree.
Note that my title is Data Services Mgr. and in that role I do some
DBAing, need to learn a lot
More Oracle 'basic' keep it in the middle of the road stuff, but where I
make my biggest impact
And consistently win annual awards (I get coins (organizational coins --
big
Title: Message
Or,
you can set event 10046, level 12 and look into the trace file. All SQL
statements in the trigger should be in there,
which
should give you a pretty good idea about what's in the trigger
itself.
Or,
you could do a systemdump level 10 and extract the trigger text from
SQL.BSQ file that creates the data dictionary is neat. Its good for getting into
arguments. Since alot of DBAs like to correct you when you say 'v$ view', they insist
'v$ table', you open sql.bsq and its 'create or replace view v_$'
There is alot of neat stuff in sql.bsq. Notes that were placed
wish i still have some of that stuff but i did receive a patch set for
oracle 7 on hpux that the developer forgot to turn off debugging for,
something in it core dumped and the .trc file had C source code in it,
back in my days of doing ALOT of C, i spoke to a developer and pointed
out where a
I want to get a 9iR2 client configured that trims all the flab
Oracle is mum on the subject and are quite satisfied at installing a gig of
client.
Even the min of 300MB is too much when it come to pushing several hundered
clients out...
ANyone have any thoughts, feelings, documents, links
Maria
I just wanted to thank you for posting your views on the DBA situation
from your perspective. I always feel better informed when I have an
opportunity to hear opinions from people whose situation is different from
mine. And I agree with you that this is a valuable forum where people with
Binley - Yes, I probably didn't phrase that too well. My understanding is
that when you create an index on a table, Oracle has to scan the table at
least once, then write to the index. My point was that if both the table and
the index are on the NetApp, your performance might be lower. Thanks for
Just to clarify, the old Oracle Masters was only an indication that
you had attended a series of relevant training courses. There was no
test, no measure of how well you could perform the role of a DBA. The
new Oracle Masters definitely addresses that issue.
Pete
Controlling developers is
Does oracle store the tablespace_name or any data about a tablespace anywhere else
accept TS$?
Im looking for base data dictionary tables. Not views. Are there any documents out
there about how oracle stores information in the data dictionary tables other than
what Steve Adams has in his book
Pete Sharman scribbled on the wall in glitter crayon:
Just to clarify, the old Oracle Masters was only an indication that
you had attended a series of relevant training courses. There was no
test, no measure of how well you could perform the role of a DBA. The
new Oracle Masters definitely
In order to run some OS commands from within the database we have set up a
few external procedures. One of the functions we need to accomplish is to
change the permissions of a file owned by a user other than oracle. As the
external procedure is executed by Oracle, this is a problem. I tried
Sounds like a project, I'll see if I can try to get each files brief
definiation and then what it's calling scripts are. Should be interesting
to see that the dependencies are.
From: DENNIS WILLIAMS [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
There are many references to TS# all over the place. If I were you, I
wouldn't
try renaming it, without being in reallly dire straits.
--
Mladen Gogala
Oracle DBA
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L
Pete, Bill
Just think though. If we'd been smart and acted like it was a terrific thing
and anyone with an Oracle Masters was top notch, then maybe we wouldn't have
to take all these darned tests.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original
you can do this all easily with a java stored procedure. alot less code. also, it will
run as the DBA group on unix.
there is an example in tom kytes book. Really short code. You can call any OS script
with it. Might be on his website too.
you then create a chmod script in unix that oracle
Funny, I found my cost (free) was acceptable ... :)
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not. It's much harder than that!
Bruce Pihlamae, long term Oracle DBA.
-Original Message-
Thater, William
Sent: Saturday, September
DENNIS WILLIAMS scribbled on the wall in glitter crayon:
Pete, Bill
Just think though. If we'd been smart and acted like it was a
terrific thing and anyone with an Oracle Masters was top notch, then
maybe we wouldn't have to take all these darned tests.
damn! NOW you tell me.;-)
--
Bill
Hi all,
We're an Oracle shop, over 140 Oracle instances.
Today, architecture has chosen IBM DB2 for BI projects.
The next step I guessed will be to choose DB2 for the new transactionnal
applications also.
IBM offers DB2 at 25% less than Oracle.
I wonder if Oracle 10G will come with a new
Pete Sharman scribbled on the wall in glitter crayon:
Funny, I found my cost (free) was acceptable ... :)
hey, can i help it of Oracle wouldn't hire me?;-)
--
Bill Shrek Thater ORACLE DBA BAARF Party member #25
[EMAIL PROTECTED]
Well, let's look at it from the purely commercial point of view:
1) Is it likely that my company will ever foot the bill for masters exam?
Me thinks not. Even OCP was frowned upon, because it was looked upon as
acquiring a technical certification that will make it easier for me to
leave
Stephane
We've been very excited about Oracle Standard Edition. Helped stave off
the interest in MS SQL. Given the budget pressures at many organizations,
I'm surprised we don't hear more about this alternative.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
Free? Vat is dis Free? All of us don't work for Oracle (at least not
directly) so we don't get that perk. But thanks for sharing.
RWB
Reginald W. Bailey
IBM Global Services - ETS SW
Mladen
I'm dubious whether Oracle will make much money from this one. Maybe
someone with better connections to the exam can clarify that one. The payoff
on anything is the amount of revenue minus the cost to create. If fewer
people take the Masters, then the revenue may not offset the cost.
Don't worry, nor do most Oracle employees. I was asked to be a beta
tester of the masters exam, and in return for my review ( we actually
spent three days doing the exam because of the amount of time discussing
whether questions were valid, how they should be marked and so on), I
got to sit the
Title: RE: Oracle Masters exam
Well, at least all of the Oracle employees can eventually claim to be masters... maybe some of them will filter over and improve the analyst stock.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
/\
/ \
/ \
\ /
\/
\
\
\
\
Few
You would need to have extproc run as some user other than oracle.
The suggested user on unix systems is 'nobody', with rather
limited privileges.
Setting it to root might prove dangerous.
Jared
Henry Poras [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/05/2003 01:29 PM
Please respond
My company it's moving all the development efforts to
SQL Server because the customers don't want to pay
Oracle licenses anymore..
Gabriel
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please
I believe that the answer to Stephane's question is obvious:
Oracle 10g will cost 10 grands/ CPU. That's where the letter g
is coming from.
--
Mladen Gogala
Oracle DBA
-Original Message-
DENNIS WILLIAMS
Sent: Friday, September 05, 2003 5:30 PM
To: Multiple recipients of list ORACLE-L
Let's just cut the crap and start our own Oracle-L Masters (OLM).
Qualifications
1) Willingness to answer questions
2) Willingness to ask questions, after RTFM
3) Willingness to publicly admit mistakes and offer corrections
4) Demonstration of advanced knowledge of Oracle
5) Able to back up
I filed a tar to get all the steps needed to do a new install of 9ias and
bring up to the current patch release 9.0.2.3.
This is their detailed list of instructions:
"
After applying 9iAS 9.0.2.0.1, you can/should apply 9.0.2.3
directly..There are some things you need to do
Title: Message
Well, that's obviously Oracle Support
version of the old Latin: Idis redibis nunquam in bello peribis.
--Mladen GogalaOracle DBA
-Original
Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John ShawSent:
Friday, September 05, 2003
what is the difference in cost between sql server and oracle? oracle claims
its similiar due to sql server needing more hard ware. now that is probably
bull in low end system, but is it accurate in high end systems?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Hi!
I think the new certification is Oracle Certified Master, but the old one
was just Oracle Master title. I personally spent over $6000 on OCM exam
which I took last year (the first public exam). I had to fly to Chicago from
other side of the world, because there were no exams available
I am getting ready to bite the bullet and do this. I have procured a copy
of Linux Advanced server to install at home, I have a couple of machines I
am going to set up to handle the RAC portions. This is tough for me,
because I am one of the largest RAC skeptics about. Of course I had to be
Here is a link to an article from McKinsey Co. My favorite positive is
that offshoring IT jobs frees Americans up to do other jobs. Now they dont
say 'what' jobs, but we are free to do them.
If you dont know these are the guys who payed Chelsea Clinton 100k/year
right out of college with no
I will try to be there as well. Possibly two of us, Alec Macdonell who
lurks about this list as well.
Steve McClure
-Original Message-
John Kanagaraj
Sent: Wednesday, September 03, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
Hi all,
We talked about this earlier and I wanted
Hi List,
Does anyone know of tools, or have had experience using tools, that will quickly convert COBOL code to Oracle. Any information you can provide would be greatly appreciated.
Thanks in advance.
Rick
So they're getting SQL Server for free?
Why not use MySQL or PostreSQL?
Jared
Gabriel Aragon [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/05/2003 03:24 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:No
Sounds like you want to rename a tablespace.
Not recommended without approval from Oracle support.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/05/2003 01:09 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
I agree, mysql is kinda like oracle v6.
joe
[EMAIL PROTECTED] wrote:
So they're getting SQL Server for free?
Why not use MySQL or PostreSQL?
Jared
*Gabriel Aragon [EMAIL PROTECTED]*
Sent by: [EMAIL PROTECTED]
09/05/2003 03:24 PM
Please respond to ORACLE-L
To:
not my call. i posted this on here before. was done
that way before i got here. Its part of the transportable tablespace plan since
you cant have multiple tablespaces with the same name in one instance.
I found some interesting(and troublesome things). I
think Oracle may not be telling us
Do you mean that the COBOL code would be translated to PL/SQL packages, or that the
COBOL I/O would be changed to SQL insert/update/select using Pro*COBOL instead of READ
and WRITE?
Or do you mean that the COBOL programs would be automagically transformed into an
Oracle database? One datafile
Or unless you have Oracle 10G. rgaffuri, are you still updating TS$, you rascal?
You could try the following:
set long 100
spool c:\temp\views.log
select
a.view_name, a.text
from
dba_views a
where
a.owner = 'SYS'
and a.view_name like 'DBA\_%' escape '\'
and exists (select *
I think this would be the perfect time for you, as DBA, to explain to the Powers That
Be that updating SYS.TS$ is a BAD idea and that the transportable tablespace plan has
to change. You have damning evidence at this point in time. You will be doing yourself
and your successors a big favour.
nah, we can afford to rebuild the instances. its just for staging anyway. Im
now more curious what is going on.
I dont think its in the datafile. I think there is more going on in memory
than Oracle is releasing.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
[EMAIL PROTECTED] wrote:
Hi List,
Does anyone know of tools, or have had experience using tools, that
will quickly convert COBOL code to Oracle. Any information you can
provide would be greatly appreciated.
Thanks in advance.
Rick
What do you mean by converting Cobol to Oracle ?
... A stupid solution might be to prefix the name of each tablespace
with the name of the database it was created in ... you might have to
play with users' quotas to allow them to create tables in the
tablespaces you have plugged in but it is infinitely better than
updating SYS tables ... I have
1 - 100 of 107 matches
Mail list logo