RE: How do you genrate primary keys?
ver a case when this > > roll-your-own approach makes sense, and is workable? > > > > * Stored sequences. I worked on one app that used a separate > > sequence for each automatically generated primary key. I > > worked on another app, a smaller one, that used the same > > sequence for more than one table. The only issue that I > > recall is that sometimes numbers would be skipped. But end > > users really didn't care, or even notice. > > > > * The SYS_GUID approach. I've never used SYS_GUID as a > > primary key generator. I wonder, was that Oracle's > > motivation for creating the function? Has anyone used it for > > primary keys in a production app? What's the real reason > > Oracle created this function? > > > > * Similar to SYS_GUID, I once worked on an obituary-tracking > > application that built up a primary key from, as best I can > > recall now: date of death, part of surname, part of first > > name, and a sequence number used only to resolve collisions, > > of which there were few. The approached worked well, > > actually, because whatever fields we munged together to > > generate a primary key gave us a unique key the vast > > majority of the time. > > > > The SYS_GUID approach is interesting, but if you need an ID > > number that users will see, and that users might type in > > themselves (e.g. social security number), is SYS_GUID really > > all that viable? > > > > Best regards, > > > > Jonathan Gennick --- Brighten the corner where you are > > http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] > > > > Join the Oracle-article list and receive one > > article on Oracle technologies per month by > > email. To join, visit > > http://four.pairlist.net/mailman/listinfo/oracle-article, > > or send email to [EMAIL PROTECTED] and > > include the word "subscribe" in either the subject or body. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Jonathan Gennick > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Mercadante, Thomas F > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > __ > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard > http://antispam.yahoo.com/whatsnewfree > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Yong Huang > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: stupid dbms_job question
JOB_QUEUE_INTERVAL I think But I found that it is obsolete in Release 9.0.1 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 23, 2003 7:15 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Re: stupid dbms_job question > > what initialization parameters? job_queue_processes is fine. > > > > From: "Gints Plivna" <[EMAIL PROTECTED]> > > Date: 2003/10/23 Thu AM 11:49:32 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: RE: Re: stupid dbms_job question > > > > Just a shot in the dark > > Have you set initialization parameters in the init file? > > > > > -Original Message- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > Sent: Thursday, October 23, 2003 6:14 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Re: Re: stupid dbms_job question > > > > > > id prefer to handle this in the database. > > > > > > > > From: "Gene Sais" <[EMAIL PROTECTED]> > > > > Date: 2003/10/23 Thu AM 10:29:33 EDT > > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > > > Subject: Re: stupid dbms_job question > > > > > > > > It's called cron :). Or you could run a shell script that executes > > then > > > > sleeps for 5 mins. > > > > > > > > >>> [EMAIL PROTECTED] 10/23/03 10:09AM >>> > > > > im trying to submit a job that runs every 5 minuts. Only way I can > > get > > > > the submit to work is as follows... > > > > > > > > variable jobno number; > > > > variable instno number; > > > > begin > > > > select instance_number into :instno from v$instance; > > > > dbms_job.submit(:jobno, 'statspack.snap;', > > trunc(sysdate+1/24,'HH'), > > > > 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); > > > > commit; > > > > end; > > > > > > > > i then do: > > > > > > > > dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; > > > > > > > > commit; > > > > > > > > my next_date column in dba_jobs is set to 15 minutes in the future, > > > > HOWEVER, it doesnt actually run. The time passes, the next_date does > > not > > > > get set again to nother 15 minutes in the future and the job doesnt > > > > run. > > > > > > > > Ive read the manual. Read metalink. read asktom and Im obvious too > > > > stupid to figure this one out. > > > > > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > > -- > > > > Author: <[EMAIL PROTECTED] > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > > > San Diego, California-- Mailing list and web hosting > > services > > > > > > - > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > (or the name of mailing list you want to be removed from). You may > > > > also send the HELP command for other information (like subscribing). > > > > > > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Gints Plivna > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > >
RE: Re: stupid dbms_job question
Just a shot in the dark Have you set initialization parameters in the init file? > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 23, 2003 6:14 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Re: stupid dbms_job question > > id prefer to handle this in the database. > > > > From: "Gene Sais" <[EMAIL PROTECTED]> > > Date: 2003/10/23 Thu AM 10:29:33 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: Re: stupid dbms_job question > > > > It's called cron :). Or you could run a shell script that executes then > > sleeps for 5 mins. > > > > >>> [EMAIL PROTECTED] 10/23/03 10:09AM >>> > > im trying to submit a job that runs every 5 minuts. Only way I can get > > the submit to work is as follows... > > > > variable jobno number; > > variable instno number; > > begin > > select instance_number into :instno from v$instance; > > dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), > > 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno); > > commit; > > end; > > > > i then do: > > > > dbms_job.interval(:jobno,'trunc(sysdate+1/96)'; > > > > commit; > > > > my next_date column in dba_jobs is set to 15 minutes in the future, > > HOWEVER, it doesnt actually run. The time passes, the next_date does not > > get set again to nother 15 minutes in the future and the job doesnt > > run. > > > > Ive read the manual. Read metalink. read asktom and Im obvious too > > stupid to figure this one out. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: <[EMAIL PROTECTED] > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Modeling
I think the main task here is practise, practise and more practise.
Prefferable under supervision of a more experienced person.
Some more books I'v read and found useful
Data Model Patterns: Conventions of Thought
http://www.amazon.com/exec/obidos/ASIN/0932633293/qid=1066746321/sr=2-1/
ref=sr_2_1/102-9109544-4984930
Case*Method: Entity Relationship Modelling
http://www.amazon.com/exec/obidos/tg/detail/-/0201416964/qid=1066747540/
sr=1-1/ref=sr_1_1/102-9109544-4984930?v=glance&s=books
The Data Model Resource Book: A Library of Logical Data and Data
Warehouse Models
http://www.amazon.com/exec/obidos/tg/detail/-/0471153664/qid=1066747769/
sr=1-8/ref=sr_1_8/102-9109544-4984930?v=glance&s=books
Gints
> -Original Message-
> From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 21, 2003 6:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Data Modeling
>
> B. S.
> I am no expert at data modeling but have made some modest attempts
in
> that direction. First, what is your objective? Casual or intense?
> I have heard that data modeling is not learned from a book, but
you
> need
> to take a class. The classes I took were so long ago and I didn't do
> anything with it so I can't vouch for that.
> If you are need to review the data models of others, get the book
"The
> Data Modeling Handbook" by Reingruber and Gregory. There is nothing
like
> it. The authors give will sound really profound and if you get
someone
> that
> wants to argue, you can point them to the book.
> There is a data modeling email list where you could get better
answers
> for this and other questions: DataModel.Org Mailing List Here are the
> removal instructions, I'm sure you can figure out how to add yourself.
> To be removed from this list, please send an E-mail to
> mailto:[EMAIL PROTECTED] in the Subject line, put "REMOVE
> {your
> email address}".
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> -Original Message-
> Sent: Tuesday, October 21, 2003 7:54 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Hi All
>
> I have not done data modelling as a major task so far. Would like to
know
> from where can I make a good start. I have basic(conceptual) knowledge
of
> ER-Diagram and Normalization. But if anybody can give me some case
> studies/links etc.,
>
> I see the responsibilities would include modelling and coping with
> Frequent
> changes of the database object structures.
>
> Please Help
>
> Thanks a Lot
>
> Regards
> B S Pradhan
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gints Plivna
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: WHERE 1 = 1 (any info on this)
> > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.net > > -- > > Author: Hately, Mike (LogicaCMG) > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 > > http://www.fatcity.com > > San Diego, California-- Mailing list and web > > hosting services > > > - > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > = > Connor McDonald > web: http://www.oracledba.co.uk > web: http://www.oaktable.net > email: [EMAIL PROTECTED] > > "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, > and...he will sit in a boat and drink beer all day" > > > Want to chat instantly with your online friends? Get the FREE Yahoo! > Messenger http://mail.messenger.yahoo.co.uk > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: =?iso-8859-1?q?Connor=20McDonald?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Hately, Mike (LogicaCMG) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to add ' (comma) at the begining and end of each line? Ei
Or text editor that can work with columns Or MSExcel > -Original Message- > From: Khedr, Waleed [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 16, 2003 5:55 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: How to add ' (comma) at the begining and end of each line? Ei > > small C, java, Perl, etc program can get it done quickly. > > -Original Message- > Sent: Thursday, October 16, 2003 10:20 AM > To: Multiple recipients of list ORACLE-L > Either Unix or Windows > > > Hi List > > I have 1000 lines in my data file. I want to add > '(comma) at the begining and end of each line. > > For example, > > abf > jd > djkhk > jd3 > > Shold be convrted to > > 'abf', > 'jd', > 'djkhk', > 'jd3', > > Any help will be really appreciated. > > Thanks > Sami > > __ > Do you Yahoo!? > The New Yahoo! Shopping - with improved product search > http://shopping.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Oracle DBA > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Using dimensions
google gave me for example such an address http://www.gaarde.org/acronyms/ I'm sure one of hundreds or even thousands > -Original Message- > From: Prem Khanna J [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 30, 2003 12:09 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Using dimensions > > Raj, > > what does TFM & STFW mean ?!! > let me also get used to the list's acronyms :) > > Jp. > > > - Original Message - > > From: Jamadagni, Rajendra > > To: Multiple recipients of list ORACLE-L > > Thanks Scott, okay lets forget OLTP .. but I haven't seen any _actual_ > uses > > of dimensions ... where does one use them? in SQLs? > > I have scanned TFM, but haven't STFW'd yet ... scared of too many hits. > > > > Thanks > > Raj > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Prem Khanna J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cron question
anyone whom could help me to tell what difference is between this mail and mail sent by [EMAIL PROTECTED] on Thu, 25 Apr 2002 12:46, as it can be found in the list archive. So the above mentioned message is: * Date: Thu, 25 Apr 2002 12:46:07 +0200 Subject: Cronjob Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh >/d31/appl/konto/log/laddabilbo.log 2>&1 Thanks in advance Roland *** And this question was answered. -Original Message- Sent: Tuesday, September 16, 2003 4:19 PM To: Multiple recipients of list ORACLE-L Hallo, anyone whom could help me with this. I am trying to use crontab -e to start a procedure. but I cant get it right. Anyone whom could help me with the command how to write if I want a program in unix to be scheduled to run every monday at 6 o´clock in the morning? Thanks in advance. Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Erm.... sorry but I need some advice (Hardware question)
On behalf of Lee Robertson Please include his address ([EMAIL PROTECTED]) in reply -Original Message- Sent: Friday, June 06, 2003 12:36 PM To: [EMAIL PROTECTED] We have a potential new client coming up who requires a 500Gb database, a mix of OLTP and batch work, about 400 users of which 100 will be concurrent. They have asked us what sort of hardware to go for !!!. Machines, processers, memory etc. We have two choices UNIX or NT (we are predominantly Digital Unix - now HP of course, but we also have AIX, but with no Oracle DBs on it yet). Can someone who has had to do this before help me out please. I have set up databases and maintained/administered them before but never got into this side of things before. Any hints/tips/white papers etc would be much appreciated. I wuold have asked on-topic but I am not subscribed at present. Regards Lee -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Skill Sets - This may be a dumb question
One advantage of database architect is that he is less dependent on a specific database. I am some kind of system architect/analyst and in my previous job I worked with Oracle products as well as with some Open source ones. Now my new company is working only with M$ SQL Server and I don't have any big problems. And they even are looking in the Oracle direction for the first time ever and of course I'm strongly supporting that :) Gints -Original Message- Sent: Tuesday, February 25, 2003 6:34 PM To: Multiple recipients of list ORACLE-L Hello everyone, Well I've been "reassigned". I was responsible for the completely messed up Peoplesoft Oracle/AIX environment but management here decided that it was more important to separate a husband and wife that both work in the same department, and assigned one of them to be primary support in this environment instead of me. (sshh: The new person who is primary doesn't know a thing about Unix.) My primary job is now suppossed to be data modeling and data warehouse/mart design, moving on into Problematica (er, Informatica) development into a Sql Server database. I will not be the admin on the Sql Server database. My new boss referred to this as "database architecture". ?? What? They have already decided what they want done and just want someone to take the pretty pictures and implement them with unrealistic deadlines. The main reason why I am upset is because it seems to me that data modeling is such a "soft" skill. I am concerned about keeping my skills up to date and keeping my hands in an Oracle environment, whether it's a mess or not. Seems to me that data modeling alone isn't something that can land you a new job or really spiff up your resume. I think that having a finite list of skills (Oracle, Unix, Windows 2000, Erwin, Project, crap like that) is more what employers search for, and is what HR depts can easily deal with. Am I wrong? This job pays well and working for a huge company has it's benefits, if you can deal with the bureaucracy similar to what is described in the 1st paragraph. And I know in this market I am just lucky to have a job. And please tell me if I'm whining. I may just need a KITA. Who knows anymore... Lisa Koivu Oracle Drink Beer Again Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: XML with ORACLE
Oracle XML DB http://otn.oracle.com/tech/xml/xmldb/content.html For all databases http://www.rpbourret.com/xml/XMLAndDatabases.htm Gints -Original Message- Sent: Monday, January 20, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Hi gurus One of my developer asked me to help in dealing with the database for XML output. I know nothing about XML. Can anyone suggest some beginers documents for XML on ORACLE. Banarasi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Automatic backup on Oracle 9i -- For Jared
Hmm, English really isn't my mother tongue, but I don't like such cryptic notations in English as well as in Latvian. It makes language more meagre and poor. Of course I also make mistakes but these are caused by my lack of knowledge and I can always accept them from another people. Gints Plivna -Original Message- Sent: Thursday, January 02, 2003 5:30 PM To: Multiple recipients of list ORACLE-L Raj - I go through episodes where I get pretty frustrated with the cryptic language, but then I take a deep breath and remember that for some people English isn't their first language. Also, I think text messages on cell phones are changing the way many people deal with English. I also get irritated with people who won't post their names. It is hard to reply to an anonymous person. But then I recall that I previously worked for a company that wouldn't let me post to newsgroups. It would be easier if people would pick a nom de plume that was more human, like "Joe Smith". Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -Original Message- Sent: Thursday, January 02, 2003 7:40 AM To: Multiple recipients of list ORACLE-L As far as we know there is no bandwidth limit on this list and problems can be understood better if you state them in a lucid and clear language. I had to really read twice (sorry haven't had my "Great One" yet) to understand the abbreviations. Am I the only one or is there anyone else who has trouble with such language? TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Tuesday, December 31, 2002 12:34 PM To: Multiple recipients of list ORACLE-L Jared what exactly U use Veritas Netbackup fr in Ur backup strategy. I use rman to take backup on disk. Please describe the role of veritas NB in detail and if u can send me example script to perform what tasks, that would be gr8. OraCop -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Methods to get DDL
Create Your own script or find one in internet that uses data dictionary. Gints Plivna -Original Message- Sent: trešdiena, 2002. gada 18. decembrī 17:16 To: Multiple recipients of list ORACLE-L I finally have a bit of time and was wondering what are different methods to get DDL other than Export rows=n Using Quest SQL navigator Using The Databee tool Ideally Id like to get it from a sql plus command but Im pretty sure that's not available. DDL dosnt seem to be available from DBA studio either... Im wondering what methods people are using? I'd like a quick way to get the ddl for say... One index Thanks in advance bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Get together at OOW
Therefore You have to find SPONSOR! Gints Plivna, Softex Latvia, Tel. 7204520 Fax 7204260 http://www.softex.lv -Original Message- Sent: Friday, November 01, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Its the classic three part story... Part 1: 20 great friends meet for the dinner Part 2: The bill arrrive "I only had one piece of garlic bread!" "You drank some of my wine!" "I shared my burger with Joe over there!" Part 3: 20 arch enemies storm out... :-) --- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote: > Personal experience with the "one check" concept and > large numbers of people > is not good. I would pressure them into say 5 > checks. Easier to > coordinate. > > Thank You > > Stephen P. Karniotis > Product Architect > Compuware Corporation > Direct: (248) 865-4350 > Mobile: (248) 408-2918 > Email:[EMAIL PROTECTED] > Web: www.compuware.com > > -Original Message- > Sent: Thursday, October 31, 2002 3:59 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Get together at OOW > > Absolutely OK! I just made the reservation at > Chevy's (3rd and Howard) for > Tuesday Nov. 12th, 7pm for 20-25 people. The only restriction is that > we put it on one check. Hopefully that will not be a > problem for anyone. > > Gerardo > > -Original Message- > Sent: Thursday, October 31, 2002 10:40 AM > To: Multiple recipients of list ORACLE-L > > > I might be able to scrounge a 7pm appearance by Anjo > Kolk, Mogens Nørgaard, > James Morle, Connor McDonald, Gaja Vaidyanatha, John Beresniewicz, > Pete Sharman, Lex de Haan, and maybe a few others if > there's room. Would that be > okay? > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > > Upcoming events: > - Hotsos Clinic, Dec 9-11 Honolulu > - 2003 Hotsos Symposium on Oracle(r) System > Performance, Feb 9-12 Dallas > - Jonathan Lewis' Optimising Oracle, Nov 19-21 > Dallas > > > -Original Message- > Gerardo > Sent: Thursday, October 31, 2002 11:39 AM > To: Multiple recipients of list ORACLE-L > > John, > > I'm planning to make a reservation (for dinner) at > 7pm for 15 people on > Tuesday 11/12/2002. We can congregate in the > cantina for drinks anytime > before then. We should have no problem changing the > number of people at the > last minute, if necessary. > > Gerardo > > -Original Message- > Sent: Wednesday, October 30, 2002 3:44 PM > To: Multiple recipients of list ORACLE-L > > > Steve, > > I will send out an invite closer to that time - say > around 6th or 7th. > > John Kanagaraj > Oracle Applications DBA > DBSoft Inc > (W): 408-970-7002 > > What would you see if you were allowed to look back > at your life at the end > of your journey in this earth? > > ** The opinions and statements above are entirely my > own and not those of my > employer or clients ** > > > -Original Message- > > From: Steve McClure [mailto:smcclure@;usscript.com] > > Sent: Monday, October 28, 2002 9:39 AM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Get together at OOW > > > > > > It looks like I will be attending this year > pending upper management > > balking at the registration fee. As for getting > together, I think > > that would be > > great, Chevy's is great as well, In fact Tuesday > evening > > looks great too. > > > > So how big a party does that make? Count me in. > > > > > > Steve McClure > > > > -Original Message- > > Sent: Saturday, October 26, 2002 8:48 PM > > To: Multiple recipients of list ORACLE-L > > > > > > > > John, > > > > Yes, it would be nice to meet. > > > > I'm not planning anything, I'll let someone else > do it. > > > > I won't be available during the day at the > conference, so > > it would be best if someone else put's something > together. > > > > My previous post didn't make it to the list: I'm > attending a couple > > of Veritas classes at the same time as the > conference, so I'll just > > be a couple miles down the road at the > Embarcadero. > > > > Jared > > > > PS. Rachel, too bad you won't be there. I'm > bringing Blazing Saddles. > > ;) > > > > On Monday 21 October 2002 16:43, John Kanagaraj > wrote: > > > Jared, > > > > > > Co
RE: Creating new user
Oh yea, my fault, didn't read mail till the end Blah, I don't know, usually if I had installed various oracle client tools like Designer, Forms, Reports etc I had also imp*. I'm sure it isn't as a standalone tool in installer, maybe it is located under tools/utilities, if I remember correctly... Last time when I installed something from oracle was at least 1.5 years ago :( Gints Plivna, Softex Latvia, Tel. 7204520 Fax 7204260 http://www.softex.lv -Original Message- Sent: otrdiena, 2002. gada 22. oktobrī 16:15 To: Multiple recipients of list ORACLE-L but my friend... i gave the command "dir imp*" and there are no files found... so now where and how and what do i use my imagination santosh -Original Message- Sent: Tuesday, October 22, 2002 6:25 PM To: Multiple recipients of list ORACLE-L There were imp73 and imp80 for appropriate versions, I don't know about more recent ones Use your imagination, friend! :-) Gints Plivna, Softex Latvia, Tel. 7204520 Fax 7204260 http://www.softex.lv -Original Message- Sent: otrdiena, 2002. gada 22. oktobrī 15:19 To: Multiple recipients of list ORACLE-L thanks ...but still i gave imp command on command prompt.. but it tells imp not found... and i checked the path also...i have given f:\oracle\bin as the path and there are no imp* files in oracle/bin. any ideas ? santosh -Original Message- Nahata Sent: Tuesday, October 22, 2002 5:40 PM To: Multiple recipients of list ORACLE-L SQL> CREATE USER IDENTIFIED BY [DEFAULT TABLESPACE TEMPORARY TABLESPACE ] for importing on command prompt imp username/password@database fromuser= touser= file= If you just want the table structure and no data then use ROWS=N option too. regards Naveen -Original Message- Sent: Tuesday, October 22, 2002 5:14 PM To: Multiple recipients of list ORACLE-L how to create a new user ? in oracle 8.1.7 ? and i want to import a dump file into that user so that i could create the tables. How to acheive this ? any help will be appreciated. Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Creating new user
There were imp73 and imp80 for appropriate versions, I don't know about more recent ones Use your imagination, friend! :-) Gints Plivna, Softex Latvia, Tel. 7204520 Fax 7204260 http://www.softex.lv -Original Message- Sent: otrdiena, 2002. gada 22. oktobrī 15:19 To: Multiple recipients of list ORACLE-L thanks ...but still i gave imp command on command prompt.. but it tells imp not found... and i checked the path also...i have given f:\oracle\bin as the path and there are no imp* files in oracle/bin. any ideas ? santosh -Original Message- Nahata Sent: Tuesday, October 22, 2002 5:40 PM To: Multiple recipients of list ORACLE-L SQL> CREATE USER IDENTIFIED BY [DEFAULT TABLESPACE TEMPORARY TABLESPACE ] for importing on command prompt imp username/password@database fromuser= touser= file= If you just want the table structure and no data then use ROWS=N option too. regards Naveen -Original Message- Sent: Tuesday, October 22, 2002 5:14 PM To: Multiple recipients of list ORACLE-L how to create a new user ? in oracle 8.1.7 ? and i want to import a dump file into that user so that i could create the tables. How to acheive this ? any help will be appreciated. Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
For other objects than tables take a look at http://www.itsystems.lv/gints/dba_selects.htm#s22 (Create "Drop" statements for a user's tables, views, sequences, functions, procedures, packages) Gints Plivna, Softex Latvia, Tel. 7204520 Fax 7204260 http://www.softex.lv -Original Message- Sent: otrdiena, 2002. gada 22. oktobrī 15:29 To: Multiple recipients of list ORACLE-L If you just don't want to drop them individually by hand, you could use sql to write sql... set head off spool droptable.sql select "drop table "||owner||"."||table_name||";" from dba_tables where owner = ; make sure the sql looks right @droptable.sql write the same kind of sql against dba_objects to get all of that user's objects... April Wells Oracle DBA --- Clinton Naude <[EMAIL PROTECTED]> wrote: > What is the syntax to delete multiple objects, or more specifically > multiple > tables from a user in 1 go. > > I need to delete 50+ tables/objects without deleting them 1 by 1. > > > > Thanks > > > > Clint > > > ATTACHMENT part 2 image/jpeg name=Sunflower Bkgrd.jpg __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gints Plivna INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
