no I have done some work with Openview but never tried to deal with
database backends, sorry
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61
Thanx Stephane . I did the same
STAARSHIP TECHNOLOGIES
www.staarship.com
Kranti Pushkarna
Project Leader
Tel: +91-22-6931557
__
Failure to prepare is preparing to
Hi list,
I have writeen a stored procedure to execute a set of stored
procedures. I want to know is there any way to stop the procedure after any
of stoed procedure( from the set) returns an error.
In simple words, is it possible to get a status whether the called procedure
was successful
Lisa R. Clary wrote:
Hi all,
I sort of come from an old school where you should normalize data where you
can (typically 3rd or 2nd) so that you get the efficiency of normalization
but not the difficulty of data extraction. Additionally, I always thought
that putting RI on tables was
Hi Kranti,
You have to add out parameter in your procedure call and to test returned
value in main procedure.
Example:
proc1( back_val OUT PLS_INTEGER, blahblah IN VARCHAR2)
AS
BEGIN
...
back_val := 1;
RETURN;
EXCEPTION
WHEN OTHERS THEN
back_val := 0;
END;
proc2( back_val OUT
kranti pushkarna wrote:
Hi list,
I have writeen a stored procedure to execute a set of stored
procedures. I want to know is there any way to stop the procedure after any
of stoed procedure( from the set) returns an error.
In simple words, is it possible to get a status whether the
Use Exceptions...
Ex.
Begin
StroedProc1
StoredProc2
Exception
When Others Then
Error Raised .. Aborting...
End;
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
Hmm,
that sounds suspiciously like Englands world famous Black Pudding/ the French
Boudin noir!
Lovely
Stuff, neverknew Denmark made it as well if it is the
same
Regards
Lee
-Original Message-From: Mogens Nørgaard
[mailto:[EMAIL PROTECTED]]Sent: 30 April 2002
Danisment,
10 Centralisation will occur.
20 Distribution will occur
30 go to 10
Anyone who's been in IT for more than about 6 years will have gone through
the cycle at least once. It's got more to do with management making a name
for themselves than any rational argument.
Money's the ONLY thing
There are two ways ..
1. Use Procedural Gateways to get at SQL Server Tables thru Oracle and do a
CTAS.
2. Bring the data onto a Flat file using the export utility in SQL Serer and
upload to Oracle using SQL Loader.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4)
Service_Name is the Db_name + db_domain. It is used by the instance for
atomatic registration to the listener ...
SID is the System Identifier which uniquely identifies your Instance. This
is used in unix to get a Memory Area.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax
The easiest is to use the SQL Server DTS utility. I use it all the time to move data
between SQL Server, Oracle, DB2 and other heterogenous sources/destinations.
Dave
-Original Message-
Sent: Tuesday, April 30, 2002 4:17 PM
To: Multiple recipients of list ORACLE-L
Hi listers,
Can
I am doing the same but I don't know why stored procedure's( the called
proc) error is not handled in my block. It is coming out of PL/sql block
sayin that my procedure is invalid.
STAARSHIP TECHNOLOGIES
www.staarship.com
XML = Extensible Markup Language, which is actually a subset of SGML ;P
(Standard Generalised Markup Language)
It allows a web type developer to create their own user defined tags, that
web applications can then pass data to other background applications to
handle - once the background app has
Thanx to all who replied on my ERD query. Much appreciated :)
Seán O' Neill
Database Administrator
Business Systems IT Department
Ext. 459
This message, including attached files, may contain
Why don't you create a linked server in SQL Server that points at the Oracle
OLEDB/ODBC driver. So long as you have Oracle client installed on the SQL
Server box you should be able to reference the Oracle tables directly.
-Original Message-
Sent: 30 April 2002 22:17
To: Multiple
That means That the Procedure is invalid ... ;-D
Try to Compile the procedure and see what error u'r getting that may help.
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
Live to
Hello Igor
Thank you for the info.
I got the following script from one of the articals that Thomas Day point to
in the message
With subject Oracle windows.
It shows the threads that oracle is using.
The first column has a call to some function that probably did some
formating but I deleted it.
Hee hee.
XML making DBAs redundant.
Sorry Mark, I know that's not what you said but I'm DBAing for an XML-based
project at the minute and I've rarely been busier.
For example, the latest version of the XDK (which Technet encourages you to
download NOW!) doesn't include the files you need to run
Title: RE: Database Normalization-Outdated?
I Admin'ed a vendor app that was built similar to this (and the UI was in Designer - made me not think kindly of Oracle duh-velopment environments). Except that they had more tables to contain all the CODES. I always referred to this nightmare
I have a script that I run to update statistics on my databases that is giving me
something odd when run on a 7.3.4 database on NT 4.0. The script runs fine on my
8.1.7 and 8.0.5 databases. It happens when the script comes to an end. Below is what
my screen looks like in SQLPlus;
SQL
Title: RE: Prod problem, please help!!! Any resolution?
Hi,
Just wondering if you made any progress?
Let us know.
Hannah
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
The Doc is the Comments Written in the file Between /* */
That comes in 8i unable to checck in 80...
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
Live to learn... forget... and learn
Farnsworth, Dave wrote:
I have a script that I run to update statistics on my databases that is giving me
something odd when run on a 7.3.4 database on NT 4.0. The script runs fine on my
8.1.7 and 8.0.5 databases. It happens when the script comes to an end. Below is
what my screen looks
Title: RE: Prod problem, please help!!! Any resolution?
Glad you asked Hannah because I was wondering the
same
John
-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]
Sent: 01 May 2002 13:18
To: Multiple recipients of list
Tracy,
We ran into some similar problems. Oracle will want
you to obtain several system state dumps when the
system is hung (we were still able to do this
connected internally through server manager). With my
limited expertise in reading state dumps the symptoms
appeared to be severe latch
Just wanted to extend my appreciation for all of your responses to this
topic. I liked the fact that even though overall, it was obvious old school
still holds, that many of you were able to show that it could be
advantageous in certain circumstances (not ours). This will make it much
easier to
Thanks Stephane. That explains it. I'll go with the -- for my comments for version
consistancy.
Dave
-Original Message-
Sent: Wednesday, May 01, 2002 8:18 AM
To: Multiple recipients of list ORACLE-L
Farnsworth, Dave wrote:
I have a script that I run to update statistics on my
Good point Hannah... even better, make them demo YOUR data. Make them prove
they can do it with data your user community (and management team) can
understand. If the demo does not make sense and the numbers are wacko,
management will never buy in to the idea.
Lisa Koivu
Oracle Database
Hi Dave,
I believe in older versions of sql*plus there was a DOCUMENTATION (DOC)
function that would spit comments back to the user with the DOC prompt. I
know I've seen this before, a long time ago. It never affected anything I
was running tho.
Lisa Koivu
Oracle Database Monkey Mama
I did not catch this one the first time around, and I've had the exact same
problem. Right now you've got a mess on your hands so I'd recommend opening an
iTAR with OTS. They are going to have some VERY interesting questions to ask
if your not into messing about in the X$ tables your in for a
If you are on SQL*Server 2000, you can use DTS (Data Transformation Services) to
unload data to Oracle.
Jim
Kader Ben [EMAIL PROTECTED] wrote:
Hi listers,
Can someone tell me how import tables from SQLServer
to Oracle.
Thanks for your help,
Ben
I don't think that this is a new idea. Back in 1979 I worked with a DBMS
that used essentially this method. It was very flexible but limited in
size since it had to be in core (cached in our terminology) in order to
perform all the joins that it needed with any response time.
You are correct that it does not affect my script, it's just annoying. A ctrl-C does
break me out of the DOC prompt and puts me back into the SQL prompt. Learned
something new. :o)
Thanks,
Dave
-Original Message-
Sent: Wednesday, May 01, 2002 9:03 AM
To: Multiple recipients of
You can use DTS in SQL Server 7.0 also to move data to Oracle.
-Original Message-
Sent: Wednesday, May 01, 2002 9:23 AM
To: Multiple recipients of list ORACLE-L
If you are on SQL*Server 2000, you can use DTS (Data Transformation Services) to
unload data to Oracle.
Jim
Kader Ben
List-
My Opinion:
The purpose of Normalization is to reduce redundant storage. It is a trade
off between affording redundancy(as far as you can?)and avoiding to many
joins later. It can not be true accross the board. Designers should go by
the merit/requirements of the application. If
Hi,
We have applied an AIX patch to our system, based upon Oracle's recommendation
(APAR IY22308). We are currently in a wait and see mode. My confidence
in this being the solution will be increased greatly if we can make it through
next Monday without the problem. (Mondays are a high-load
Hi gurus,
Oracle 816, java application.
I had a discussion with my co-workers on where
all the SQL statements should reside. In client
code (java) or in stored procs called by the java
client?
It's an internet application, so basically they're
only
a 'select' statements. Some of us prefer to
HI LIST,
WHAT'S THE BEST WAY TO STORE BLOB,CLOB OBJECT IN A TABLE WITHIN OTHER TYPE
ON DATA, IS THERE ANY WAY TO RECORD THE PATH OF THE CLOB,BLOB OBJECT IN A
TABLE AND STORE THE BLOB,CLOB IN ANOTHER TABLE LIKE THIS:
TABLEA
COL1 NUMBER
COL2 VARCHAR2(35)
COL3 path for CLOB --tableb COL1
Tracy - You might still want to get STATSPACK running. It may provide
valuable information on what is happening.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, May 01, 2002 11:18 AM
To: Multiple recipients of list ORACLE-L
Hi,
We have
To speak to that point; we are the state tax department. We received and
send mail, hundreds of pieces. Our original tax appliation required us to
go to at least10 tables to get an address because it was completely
normalized. When we go the new and improved version this was denormalized
for
I agree whole-heartedly. Besides, what that consultant is describing is
just the logical view of x.500, LDAP or something like it. Its how you
logically view that type of database. If you look at most LDAP
products, the internal structure of the database is relational and
highly normalized.
All,
Might as well add my 2 cents.
I say Normalize as we are supposed to, and not worry about designing an OLTP
database for use by the latest query/reporting tools.
Lets face it, COGNOS and the rest just plain do not work against OLTP
databases anyway. We end up either designing and
HI AGAIN,
JUST WANT TO CHECK WITH YOU GUYS, MY LISTENER.LOG IS GETTING BIG I TRY TO
RENAME IT THEN CREATE A NEW LISTENER.LOG BUT STILL THE OLD ONE IS USING BY
ORACLE.
HOW CAN I TRUNCATE THE LISTENER.LOG OR CAN I JUST SIMPLY DELETE IT OR NOT?
THANKS FOR HELP.
Hamid Alavi
Office 818 737-0526
I'm working with a program that accesses a table with a LONG datatype. The
program was originally written to manipulate a VARCHAR2(60) with instr and
substr functions. The language (SQR) allows me to dump the info into a variable
and supposedly work with it, but it won't compile. Does
Normalization process should be done at the logical level, but it can be
denormalized at the physical level to support must have transaction
processings.
-Original Message-
Sent: Wednesday, May 01, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L
To speak to that point; we are
Hamid,
Move it to alert_log.yymmdd if you need to save it, else remove it. The file
will be auto-created by Oracle the next time it writes to it.
Thank you,
Paul Sherman
DBAElcom, Inc.
voice - 781-501-4143 (direct #)
fax- 781-278-8341 (secure)
email - [EMAIL PROTECTED]
Whatever happend to COBOL anyway?? That was so easy to code, along with
Fortran, BASIC, Pascal was a lot of fun. What's wrong with storing your
data in VSAM files???
I think I hear my pasture calling me...35, and retired...that would be nice.
I can write COBOL books to fund my retirement...
Hmmm...if Oracle hosts my database, and something bad happens, and it goes
down for the day.
Is Oracle going to pay me for the downtime? I think not.
Is Oracle going to reimburse me for all the sales I lost? I think not.
I'm sure some Oracle rep will make me all kinds of promises that
For Unix:
cp -p listener.log listener.log.old
echo listener.log
Or you can disable logging completely using logging_listener=off in
listener.ora
Hamid Alavi wrote:
HI AGAIN,
JUST WANT TO CHECK WITH YOU GUYS, MY LISTENER.LOG IS GETTING BIG I TRY TO
RENAME IT THEN CREATE A NEW
What complications ?
REF CURSOR to JAVA is really easy using 'ResultSet'
Regards,
Waleed
-Original Message-
Sent: Wednesday, May 01, 2002 12:18 PM
To: Multiple recipients of list ORACLE-L
Hi gurus,
Oracle 816, java application.
I had a discussion with my co-workers on where
all the
What OS? Oracle version?
Oh yeah, stop SHOUTING. We can hear you just fine here on the Good Ship
Lollipop.
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: Hamid Alavi [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 12:18 PM
To: Multiple recipients
Hamid,
Ignore my e-mail, as I had alert_log in the brain, not listener. As for the
listener, for most versions, you would have to stop the listener, remove it,
then restart it.
Thank you,
Paul Sherman
DBAElcom, Inc.
voice - 781-501-4143 (direct #)
fax- 781-278-8341 (secure)
email -
ERWin and ERStudio are basically in the 3,000 to 4,000 price range,
depending on what add-ons you take and yearly maintenance license.
When I reviewed them in 2001Q4, ERStudio was the only one that had a network
option. In other words, you can install the software on every PC in the
company but
cat /dev/null listener.log.
-Original Message-
Sent: Wednesday, May 01, 2002 12:18 PM
To: Multiple recipients of list ORACLE-L
HI AGAIN,
JUST WANT TO CHECK WITH YOU GUYS, MY LISTENER.LOG IS GETTING BIG I TRY TO
RENAME IT THEN CREATE A NEW LISTENER.LOG BUT STILL THE OLD ONE IS USING
If you are running Oracle on Windoze, you have to stop the listener service, then
rename the listener.log, then start the listener service again. I don't know how on
Unix.
Dave
-Original Message-
Sent: Wednesday, May 01, 2002 12:18 PM
To: Multiple recipients of list ORACLE-L
HI
Actually, like most everything else, it depends on platform and version.
OpenVMS, for example, will not recreate the file. In this case, you must:
1) lsnrctl set log_file temp_name
2) rename $ORACLE_HOME/network/log/listener.log to something else.
3) lsnrctl set log_file listener
You'll have to stop listener in order to remove listener.log (otherwise, the
file is locked).
If you are not interested in the info, which is in listener.log, you can
just specify LOGGING_LISTENER=OFF in your listener configuration file.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original
stop the listener, then rename or delete it. (It won't matter.) Then
restart the listener and you will have a new log.
From: Hamid Alavi [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: SIMPLE QUESTION
Date: Wed, 01 May 2002
Hi all,
I want to know when you want to create a new database before that do you
have to create a new instance first if yes HOW?
This is my first step for create a new database(or instance).
ORACLE_SID=TEST
export ORACLE_SID
CONNECT INTERNAL
STARTUP NOMOUNT PFILE ='PATH/initTEST.ORA' - BUT
Hamid,
the following command:
lsnrctl set log_status off
will stop logging connections to the listener.log file.
the following command:
lsnrctl set log_file listener1.log
will create a new file called listener1.log. you could then delete the
original listener.log file (I have YET to find a
Switch the logfile location to another directory using 'lsnrctl set
log_directory', rename the old log, switch the destination back.
-Original Message-
Sent: Wednesday, May 01, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L
HI AGAIN,
JUST WANT TO CHECK WITH YOU GUYS, MY
Here is what we did.
1. Disable VCS;
2. lsnrctl set current_listener LISTENERedb;
3. lsnrctl set log_status off;
4. rename listeneredb.log to listeneredb.log.old;
5. lsnrctl set log_status on.
-Original Message-
Sent: Wednesday, May 01, 2002 1:18 PM
To:
I want to write a database trigger that will insert
a new record into a log table whenever there is an
update action on a particular table.Is there a way
ofstoringinto the log tablethe actual update command
that was issued
againt the table.
Ex:
I have a database trigger that fires when
Chris,
Our company as well as many others do host databases for our customers and
yes we have SLA's which specify financial costs associated with not meeting
them. Oracle is not doing anything new in this sense.
Thanks,
Ethan Post
perotdba (AIM), epost1 (Yahoo)
You have to have the listener down to rename or delete it. Just shut the
listener down for a second, rename the file or delete it, and restart the
listener.
HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 01, 2002 1:18 PM
Something like this, your paths may vary...
copy C:\build_db\initDB.ora D:\Admin\YOURSID\PFILE\initYOURSID.ora
pause
set ORACLE_SID=YOURSID
oradim -new -sid YOURSID -intpwd superman -startmode manual -pfile
D:\Admin\YOURSID\PFILE\initYOURSID.ora
svrmgrl @C:\build_db\build_tablespace.sql
oradim
Hi,
You can truncate the listener.log without stopping the listener by doing
this:
cat /dev/null listener.log
It won't interrupt the flow of information into the file because it
maintains the same inode value.
Regards,
Mike Hately
PS notice how truncating listener.log is more meaningful
OFF TOPIC...
Oracle stock is down 11% today.
What gives? Over-reaction to executive departures and decreased revenues?
Is it a good time to invest?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Orr, Steve
INET: [EMAIL PROTECTED]
Fat City Network Services
Title: RE: SIMPLE QUESTION
Actually it can be done without restarting the listener
lsnrctl set log_file new_log_file_name
[re]move the old log file
lsnrctl set log_file old_log_file_name
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Reason is 6/7ths of treason. - The Xtals
Oops! I forgot about that..RBG
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 01, 2002 2:28 PM
Hi,
You can truncate the listener.log without stopping the listener by doing
this:
cat /dev/null listener.log
It won't interrupt
In terms of adding information to this discussion, here is an article in
Infoworld. You'll have to paste the URL back together.
http://www.infoworld.com/articles/se/xml/02/04/29/020429seoracle.xml
The sentence that caught my eye is: Just when we thought we had seen them
all, a new twist to
When I try to use YAPP to analyze my STATSPACK report, I get an error
message which states that my SQL is wrapping or too long. It says that I
should set my pagesize and linesize correctly.
The report looks o.k. to the naked eye.
I looked all over their website but I don't see anywhere that
You have to create a new instance first. You do this by using the ORADIM
utility or you could use database configuration assistant. I think most
folks prefer oradim. You did not say what platform/version. This is for
Oracle 8.1 on Win NT/2000
Oradim syntax
ORADIM -NEW -SID SID -INTPWD
http://www.cnu.org/
| New Urbanism is an urban design movement that burst onto the
| scene in the late 1980s and early 1990s. New Urbanists aim to
| reform all aspects of real estate development. Their work affects
| regional and local plans. They are involved in new development,
| urban
Talking of forums (fora ?) of Oracle-L members,
it occurred to me that I haven't seen Mogens
mention here DBF 2002 which he is organising
in Sydney on May 27th / 28th.
Apart from putting up with Mogens talking, there
is a dazzling array of well-informed individuals
who have volunteered to give
Hamid,
Stop the listener, delete the file, then restart it.
lsnrctl stop
delete the log or rename it
lsnrctl start
It will take less than a minute. If this isn't a very important server you
can do it quickly during the day - but use your judgment on that, don't want
to get you fired.
HTH
You will also have to run your create database command giving the system
tablespace and redo log locations. You will want to create a rollback
segment or two and then edit your init file to include the rollback segments
at start time. Then create your tablespaces and you should have an empty
Cherie,
Send the report to me, so I can have a look what is causing the problem. On
the secondary upload site, this shouldn't be a problem anymore. It may fail on
the primary.
Anjo.
[EMAIL PROTECTED] wrote:
When I try to use YAPP to analyze my STATSPACK report, I get an error
message
I've used the release of Embarcadero's ERSudio that was new about two months
ago. It is OK if you really just want to do modeling and have relatively
low expectations for some of hte more advanced capabilities of such tools.
If does a decent job with diagrams and its rather simple standard
It is kind of amazing how irrelevant and lacking in substance this
discussion is.
It has been explained that the original offender's email server was
configured in *stupid mode* because of damagement, not because of
the techies.
fyi: PHB = pointed headed boss
(
Hi All! Happy Wednesday!
I have been reading lately (on the list and in other materials)
about the venerable Cache Hit Ratio not really being a good
measure of performance. I agree, but there's something I can't
quite grasp.
I have this performance report from one of my data marts (the
Oracle 8.1.7 on sun solaris.
-Original Message-
Sent: Wednesday, May 01, 2002 12:58 PM
To: Multiple recipients of list ORACLE-L
You have to create a new instance first. You do this by using the ORADIM
utility or you could use database configuration assistant. I think most
folks
See my old posting at
http://faqchest.dynhost.com/prgm/oracle-l/ora-01/ora-0105/ora-010521/ora01052411_15995.html
Brian P. MacLean
Oracle DBA, OCP8i
ERWin's not much better. Has some better modeling capability as you might guess, but
has some VERY annoying quirks too. You also need to drill down endlessly when doing a
compare and I have seen it see two exact tables (even case being the same) and see
them as different. The DO have a
Hmmm, I'm guessing you're a student at csus and not a professional
there. Grow up.
-Original Message-
Sent: Wednesday, May 01, 2002 4:42 PM
To: Multiple recipients of list ORACLE-L
It is kind of amazing how irrelevant and lacking in substance this
discussion is.
It has been
If this is unix, do this...
1. backup the log if you need it
2. issue this command listener.log (this will initialize the log)
-Original Message-
Sent: Wednesday, May 01, 2002 1:18 PM
To: Multiple recipients of list ORACLE-L
HI AGAIN,
JUST WANT TO CHECK WITH YOU GUYS, MY
Ball in your court, Mr. Pierce.
--Walt Weaver
Bozeman, Montana
-Original Message-
Sent: Wednesday, May 01, 2002 3:00 PM
To: Multiple recipients of list ORACLE-L
Hmmm, I'm guessing you're a student at csus and not a professional
there. Grow up.
-Original Message-
Sent:
Lisa,
Any chance of getting the name of both the consultant and the book?
Jared
Lisa R. Clary [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/30/2002 12:48 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:
Here's
a quick-n-dirtySQL that pivots the result set into one row. It has
its limits (you must know the number of rows that would be returned so that you
can adjust the grouping columns value01 through value12.
SELECT
g1
,MAX(DECODE(line_no,01,value,NULL)) value01
As jared says keep querying the session_Wait u will defnetly bound to
catch
the guy who might be causing the database to kneel down.
If the database is hung, the waits will likely show up immediately. I've
had
similar problems with waits on a latch that hung the database. If a
session
is
I am on Solaris using 8.1.7.3 to create an istance
1. startup nomount pfile=initsid.ora - run this from svrmgrl connected
internal
2. create database command
3. run catalog and catproc (i also run catexp)
4. create my tablespaces
5. create my rollback segments
6. edit initsid.ora to load
Weaver, Walt wrote:
Ball in your court, Mr. Pierce.
--Walt Weaver
Bozeman, Montana
-Original Message-
Sent: Wednesday, May 01, 2002 3:00 PM
To: Multiple recipients of list ORACLE-L
Hmmm, I'm guessing you're a student at csus and not a professional
there. Grow up.
Was
Am I speaking to the wind
For Compares, why would you compare the MODEL with the
DATABASE...like going from US to London via Tokyo...
... and you get to pay more, like... you pay not for
distance, but for time in the air... If a tool takes
longer to do something, makes more mistakes, is
Well, for one thing, if your developer, Dom Phoc, starts changing crap in
your database (as has happened to me in the past) a compare to the dev model
would be great because my development changes would be in the model, not in
the test or production databases. In that specific case I had to
I am actually having the same probs now there is a database which is is
getting froze for a few secs nobody can login but we did not know what time
this was occuring.
set a recording thro 9i for every sec later we came to know it was due to
cache buffer chain. almost 90 to 100 people were waiting
ERWin change the column sequences when using Reverse Engineering to generate
diagram. It puts all of primary key columns on the top. But, actually some
primary key columns are in the middle of table. That is really bad. Does
anybody see the same problem?
-Original Message-
Sent:
I have seen it create two columns with the exact same name in a table. It
did this by putting double quotes around the column it was adding (that
actually already existed.)
What's so bad about moving the pk fields to the top? Why would you put them
in the middle of the table? I think having
You can drag a long directly into a varchar2(32767) in
pl/sql. If the longs are larger than this, then you
need to use dbms_sql (or 3gl) to drag it out in
pieces.
hth
connor
--- Alan Carbutt [EMAIL PROTECTED] wrote: I'm
working with a program that accesses a table
with a LONG datatype. The
Having seem some of the presenters in action, I can
heartily recommend the seminar in Oz to anyone that
can get there...I can also heartily recommend Oz as
easily the best place on the planet! (touch of bias)
... also interesting is that under my piddly old
Netscape 3 I can see the Great Buy
1 - 100 of 110 matches
Mail list logo