Search the web
Sign In
New User? Sign Up
VOUGlist · Virginia Oracle User's Group
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want to share photos of your group with the world? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Messages 894 - 923 of 923   Newest  |  < Newer  |  Older >  |  Oldest
Messages: Show Message Summaries   (Group by Topic) Sort by Date v  
#923 From: m arju <a_arju@...>
Date: Sun Jul 6, 2008 5:58 am
Subject: New Feature of 10.2g: Eliminate Control File Re-Creation
a_arju
Offline Offline
Send Email Send Email
 
New Feature of 10.2g: Eliminate Control File Re-Creation
Before Oracle 10.2g if we need to change the limit of MAXLOGFILE,
MAXLOGMEMBERS, MAXLOGHISTORY, MAXDATAFILES, and MAXINSTANCES then the
possible solutions is either RE-create new controlfile or create a new
database.

But
from Oracle 10.2g all sections of the control file are now
automatically extended when they run out of space. This means that
there is no longer a requirement to re-create the control file when
changes in the configuration parameter the MAXLOGFILE, MAXLOGMEMBERS,
MAXLOGHISTORY, MAXDATAFILES, and MAXINSTANCES are needed.

Two different Sections of Control file:
--------------------------------------------

Visit
http://arjudba.blogspot.com/2008/04/new-feature-of-102g-eliminate-control.html

http://arjudba.blogspot.com



       __________________________________________________________
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at
Yahoo! http://uk.docs.yahoo.com/ymail/new.html

[Non-text portions of this message have been removed]

#922 From: "Bob" <rs2wq@...>
Date: Wed May 21, 2008 5:47 pm
Subject: Convert diacritical (international) characters
uvabob
Offline Offline
Send Email Send Email
 
We are using:
NLS_CHARACTERSET       WE8ISO8859P15,
NLS_NCHAR_CHARACTERSET UTF8
NLS_LANGUAGE           AMERICAN
on 10.2.0.3.0 Oracle DB,
Does anyone know how to convert from diacritical (international)
characters to ascii in sql (view) as one of our legacy systems cannot
handle non-ascii characters?

I've tried
select name,
        convert(name, 'US7ASCII', 'WE8ISO8859P15')
from UV_AD_IMAGENOW_BIODEMO

results:
SæBø,Håkon  S?B?,H?kon

TIA

#921 From: "Madu Upadhya" <mk.upadhya@...>
Date: Wed Apr 2, 2008 1:28 pm
Subject: Re: Dates in export log files
mk_upadhya
Offline Offline
Send Email Send Email
 
I would do it by writing a batch file as follows:

export.bat
-------------------------------------------------------------
time /t > exp.log
exp userid=<USERID>/<PW>@<DATABASE> file=<EXP_FILENAME>.dmp
log=exptmp.log tables=(TABLE1,TABLE2,...)
time /t >> exptmp.log
type exptmp.log >> exp.log
del exptmp.log
-------------------------------------------------------------

-Madu

--- In VOUGlist@yahoogroups.com, "wbuker" <whbuker@...> wrote:
>
> Folks,
>
> We are doing daily exports as part of our backup strategy. We are
> working in a windows environment and with Oracle 10.0.2.0.3.
>
> I would like to see a time the export started in the export log file
> and the time the export completed in the same log file.
>
> Here is what I have tried. If I create a log file using notepad, and
> on the command line say: call time /t >> cb190t3.log, it will put the
> time in there fine.
>
> Then if I run my export and tell it to put the results in the same
> log, it will overwrite what I have already entered. So I need some
> help figuring out how to put the time it started, the export log, and
> the time it finished.
>
> Thanks in advance,
>
>
> Bill Buker,
> Enterprise Database Manager
> Swansons Services
> whbuker@...
>

#920 From: "Mark C. Stock" <mcstock@...>
Date: Tue Apr 1, 2008 5:27 pm
Subject: Re: Dates in export log files
mcstock@...
Send Email Send Email
 
Echo your start and end time to a different log, then append that log to the exp
log when exp is done

-- Mark C. Stock
     enQuery

   ----- Original Message -----
   From: wbuker
   To: VOUGlist@yahoogroups.com
   Sent: Tuesday, April 01, 2008 9:45 AM
   Subject: (VOUG) Dates in export log files


   Folks,

   We are doing daily exports as part of our backup strategy. We are
   working in a windows environment and with Oracle 10.0.2.0.3.

   I would like to see a time the export started in the export log file
   and the time the export completed in the same log file.

   Here is what I have tried. If I create a log file using notepad, and
   on the command line say: call time /t >> cb190t3.log, it will put the
   time in there fine.

   Then if I run my export and tell it to put the results in the same
   log, it will overwrite what I have already entered. So I need some
   help figuring out how to put the time it started, the export log, and
   the time it finished.

   Thanks in advance,

   Bill Buker,
   Enterprise Database Manager
   Swansons Services
   whbuker@...

#919 From: Bill Zakrzewski <bill@...>
Date: Tue Apr 1, 2008 5:17 pm
Subject: Re: Dates in export log files
bill@...
Send Email Send Email
 
Bill -

I don't work on windows much so I am not familiar with the commands, but
how about the following steps.

1. Capture the start time in a file - start_time.log
2. Run the export
3. Capture the end time in a file - end_time.log
4. Concatenate start_time.log with export.log with end_time.log

HTH
-Bill

wbuker wrote:
>
> Folks,
>
> We are doing daily exports as part of our backup strategy. We are
> working in a windows environment and with Oracle 10.0.2.0.3.
>
> I would like to see a time the export started in the export log file
> and the time the export completed in the same log file.
>
> Here is what I have tried. If I create a log file using notepad, and
> on the command line say: call time /t >> cb190t3.log, it will put the
> time in there fine.
>
> Then if I run my export and tell it to put the results in the same
> log, it will overwrite what I have already entered. So I need some
> help figuring out how to put the time it started, the export log, and
> the time it finished.
>
> Thanks in advance,
>
> Bill Buker,
> Enterprise Database Manager
> Swansons Services
> whbuker@... <mailto:whbuker%40swansons.net>
>
>

#918 From: "wbuker" <whbuker@...>
Date: Tue Apr 1, 2008 1:45 pm
Subject: Dates in export log files
wbuker
Offline Offline
Send Email Send Email
 
Folks,

We are doing daily exports as part of our backup strategy. We are
working in a windows environment and with Oracle 10.0.2.0.3.

I would like to see a time the export started in the export log file
and the time the export completed in the same log file.

Here is what I have tried. If I create a log file using notepad, and
on the command line say: call time /t >> cb190t3.log, it will put the
time in there fine.

Then if I run my export and tell it to put the results in the same
log, it will overwrite what I have already entered. So I need some
help figuring out how to put the time it started, the export log, and
the time it finished.

Thanks in advance,


Bill Buker,
Enterprise Database Manager
Swansons Services
whbuker@...

#917 From: "Rumpi" <rgravens@...>
Date: Wed Oct 24, 2007 5:14 pm
Subject: Re: Oracle 10g - outer joins
akrongrav
Offline Offline
Send Email Send Email
 
<snip>
Did the (+) notation used in outer joins "go away" in version 10g?
</snip>

No.  But perhaps it should.

The ANSI OUTER join syntax is more readable and now the preferred
method as stated in the Oracle documentation set.  See
http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/queries00
6.htm#i2054012

where it states:

"Oracle recommends that you use the FROM clause OUTER JOIN syntax
rather than the Oracle join operator. "

More details on why can be found in the link.

#916 From: "Worthington, Richard" <worthinr@...>
Date: Wed Oct 24, 2007 2:05 pm
Subject: RE: Oracle 10g - outer joins
worthinr@...
Send Email Send Email
 
Nope.  I use it all the time.


	 -----Original Message-----
	 From: VOUGlist@yahoogroups.com [mailto:VOUGlist@yahoogroups.com]
On Behalf Of Larry Blankenship
	 Sent: Thursday, October 18, 2007 4:07 PM
	 To: VOUGlist@yahoogroups.com
	 Subject: *VOUG* Oracle 10g - outer joins



	 Hiya All,

	 Did the (+) notation used in outer joins "go away" in version
10g?

	 Curiously yours,

	 LB.

	 ==========================

	 Lawrence Blankenship '07

	 Hollins University

	 Computer Services

	 540-362-6487

	 ==========================

#915 From: Virginia Oracle User's Group <vouglist@...>
Date: Wed Oct 24, 2007 2:07 pm
Subject: Re: Session Presentations
vouglist
Offline Offline
Send Email Send Email
 
Larry - The session presentation handouts from our conference earlier this month
are posted and ready for download!

Here's a direct link:  http://www.voug.org/presentations.asp

You can click on the presentation title to download its handout (note that some
presenters don't have handouts, so if we didn't receive one then there won't be
a link in the title)

---

Craig Warman
VOUG Listserv Moderator


--- Larry Blankenship <lblankenship@...> wrote:

>  Hiya All,
>
>   I was a first time participant at the VOUG Conference held earlier
> this month. (The best conference I have been to in recent memory, hands
> down.)   Did I understand correctly that session presentations would be
> made available to members of this listserv? Perhaps it is already
> available, and I missed it?
>
> Thanks!
>
> J
>
>
>
> ==========================
>
> Lawrence Blankenship
>
> Hollins University
>
> ==========================
>
>

#914 From: "Larry Blankenship" <lblankenship@...>
Date: Thu Oct 18, 2007 8:07 pm
Subject: Oracle 10g - outer joins
lblankenship@...
Send Email Send Email
 
Hiya All,

Did the  (+)  notation used  in outer joins "go away" in version 10g?

Curiously yours,

LB.





==========================

Lawrence Blankenship '07

Hollins University

Computer Services

540-362-6487

==========================

#913 From: "Larry Blankenship" <lblankenship@...>
Date: Wed Oct 17, 2007 6:22 pm
Subject: Session Presentations
lblankenship@...
Send Email Send Email
 
Hiya All,

   I was a first time participant at the VOUG Conference held earlier
this month. (The best conference I have been to in recent memory, hands
down.)   Did I understand correctly that session presentations would be
made available to members of this listserv? Perhaps it is already
available, and I missed it?

Thanks!

J



==========================

Lawrence Blankenship

Hollins University

==========================

#912 From: "vouglist" <vouglist@...>
Date: Fri Sep 14, 2007 3:08 pm
Subject: Keynote, Last Chance for Discount
vouglist
Offline Offline
Send Email Send Email
 
VOUG Membership - Well, today's the day - the last chance for you to take
advantage of the discount we offer to our members and past attendees!  It's for
our big Fall conference in a few weeks: October 4th and 5th (Thurs & Fri) to be
exact, in Charlottesville, VA.

How To Get The Discount
-----------------------
When you fill out the conference registration form at http://www.voug.org you'll
see a field marked "VIP Passcode".  Type the word MEMBER in that field, and make
sure you choose "VIP Passcode" in the "Registration Rate" drop-down box.  This
gets you through the door for $235 for both days - but make sure you do it
before COB today!

The Keynote
-----------
In case you haven't heard, Oracle has really stepped up its support of the user
group community, and our keynote speaker is a prime example.  He's Charles
Garry, Director, Product Management of Oracle Server Technologies, and his
keynote address will focus on how organizations can leverage 11g to achieve
infrastructure agility.  This is an excellent choice - right now, IT
organizations continue to struggle with how the demands of their consumers (fast
turn-around times, flexibility, high availability) can be reconciled with the
practical limitations of the technology.  It's a great opportunity to learn how
Oracle's engineers have addressed those issues with 11g, and how you can take
practical advantage of those advances.

Mr. Garry brings over 20 years of IT experience to the table.  He has served as
the former Vice President and Director for META Group’s Technology Research
Services and has worked with hundreds of companies delivering support and
education in database design, performance tuning, backup/recovery, licensing,
and negotiation strategies.  He presents regularly at Oracle World, IOUG, IDUG,
Teradata Partners and the MySQL User Conference, and was the author of a regular
column for eWEEK.com.  This is a guy that understands the industry and knows the
technology.

See you in Charlottesville!

Craig Warman
VOUG Listserv Moderator

VOUG 2007
Doubletree Charlottesville Hotel
Charlottesville, VA
October 4-5, 2007
http://www.voug.org/

#911 From: "vouglist" <vouglist@...>
Date: Wed Sep 12, 2007 11:49 am
Subject: Conference Presentation Highlights: Security (part 2)
vouglist
Offline Offline
Send Email Send Email
 
VOUG Membership - As I mentioned in the last presentation highlights, Oracle
security has become a dominant theme in our line of work.  And so it follows
that it's also one of the largest tracks in this year's VOUG conference.

Discount for VOUG Members
-------------------------
If you haven't already registered, you'll definitely want to take advantage of
our discount to members that ends on Friday.  When you fill out the conference
registration form at http://www.voug.org you'll see a field marked "VIP
Passcode".  Type the word MEMBER in that field, and make sure you choose "VIP
Passcode" in the "Registration Rate" drop-down box.  It's that easy - but you
have to do it before Friday the 14th.


Presentation Highlights
-----------------------
Here's the second of two rounds of highlights for security-related
presentations:

60 Security Tips in 60 Minutes
Kenny Smith, Consultant
You traveled all this way to the conference to either relax, network, vacation,
or learn something new. Recently, database security has been a hot topic that
needs attention. During this presentation, you'll get a boatload of security
tips and tricks - including encryption, hacking, and auditing - you'll find
helpful back at your office.


A New Look at a Popular Attack Vector on Databases: SQL Injection
Dan Sarel, Sentrigo
SQL injection is still one of the top threats to database security. While some
SQL injection attacks can be prevented using simple methods, others exploit
vulnerabilities that are far more difficult to detect and address. We will
explain and demonstrate such attacks and show how they can be stopped.

How Can Oracle Production Data Be Securely Used in a Test System?
Ulf Mattsson, Protegrity
Production data is in many cases needed to ensure quality in system testing. Key
data fields that can be used to identify an individual or corporation need to be
cleansed to de-personalize the information. A solution must be based on secure
encryption, robust key management, separation of duties, and auditing.

Database Security and Compliance—Oracle Solutions
Ran Pan, Consultant
Data security is one of the most crucial elements in today's business and
securing the database is a complex endeavor. To protect your data assets against
any internal and external threats requires integrating security policies,
measures, and technologies.  This presentation will review common
vulnerabilities in database security, discuss the current challenges and steps
to take to protect the enterprise data assets, and offer an in-depth insight
into Oracle security architecture and models, and solutions.


------
See you in Charlottesville!

Craig Warman
VOUG Listserv Moderator

VOUG 2007
Doubletree Charlottesville Hotel
Charlottesville, VA
October 4-5, 2007
http://www.voug.org/

#910 From: "vouglist" <vouglist@...>
Date: Fri Sep 7, 2007 8:25 pm
Subject: Conference Presentation Highlights: Security (part 1)
vouglist
Offline Offline
Send Email Send Email
 
VOUG Membership - We're just a few weeks away from our Fall conference on Oct
4-5 (Thurs/Fri) in Charlottesville, VA.  For those of you who haven't already
registered, you'll definitely want to take advantage of our discount to members
that ends on this Friday, September 14th.

How To Get The Discount
-----------------------
When you fill out the conference registration form at http://www.voug.org you'll
see a field marked "VIP Passcode".  Type the word MEMBER in that field, and make
sure you choose "VIP Passcode" in the "Registration Rate" drop-down box.  It's
that easy - but you have to do it before Friday the 14th.


Presentation Highlights
-----------------------
As you know, Oracle security is a very hot topic, and one of the largest tracks
in this year's conference.  Here's the first of two rounds of highlights for
security-related presentations:

The Data Protection Landscape: Integrating Data Auditing with a Layered Defense
Brad Foreman, Tizor Systems
There are many approaches to protecting data including data auditing, data
monitoring, encryption, data leakage prevention, endpoint monitoring, and
others.  Do you know which combination of approaches is best for your company?
In this presentation we will discuss where the various data protection
technologies fit into an effective data security strategy and provide
information on how to build a layered data protection defense system for your
organization.

Better R11i Security in 3 Days - Keeping the Bad Guys Away
Randy Giefer, Solution Beacon
Terrorism, identity theft, 9/11.  It's no longer a safe world, and corporate
data needs to be protected from not only the external bad guys, but also the
internal ones as well!  Many companies believe this won't happen to them - until
it's too late.  This presentation is the second in the series following the
popular "30 Minute Release 11i Security - Keeping the Bad Guys Away" and
provides real-world examples and best practices of how substantial security
benefits can be obtained in just a few days. Security tips and tricks specific
to the Oracle Applications will also be provided to enable administrators to
protect their data from "the bad guys."

An Enterprise Database Security Project—A Case Study
Ulf Mattsson, Protegrity
This session is a case study about an Enterprise Database Security project
including the strategy that focuses on Oracle Database security. It presents the
current state of database security tools and processes, the current needs of a
typical enterprise organization, and a plan for evolving the database security.
It includes the current state of database security tools for Oracle8, 9, and 10,
the current needs of a typical enterprise organization, and a plan for evolving
the database security.

Data Privacy...The Internal Threat
Eric Offenberg, Princeton Softech
Privacy breaches are making headlines, as organizations scramble to protect the
confidentiality of their critical customer and business data. While companies
are making great strides in protecting data privacy in production application
environments, the idea of implementing similar strategies in their testing
environments is often overlooked. Taking a proactive strategy to combat this
internal threat will remove this vulnerability within your enterprise.  Join us
for a presentation on combating the internal threat to your application
databases and learn how to protect your organization.


------
See you in Charlottesville!

Craig Warman
VOUG Listserv Moderator

VOUG 2007
Doubletree Charlottesville Hotel
Charlottesville, VA
October 4-5, 2007
http://www.voug.org/

#909 From: "octeres" <octeres@...>
Date: Wed Aug 22, 2007 2:32 pm
Subject: I need to find orancrypt8.dll
octeres
Offline Offline
Send Email Send Email
 
Hi!

I had a bad install of a homegrown Siebel application with Oracle 8i
as a back end.  It was removed and reinstalled.

My problem I lost my oracle ODBC connection to my main application.  I
have an error message saying that I need:

* orancrypt8.dll.

Can anyone point me in the right place?  My company has some sort of
relationship with Oracle but I am far removed from that and do not
have that option.

Regards,

Andrew

#908 From: Larry Blankenship <lblankenship@...>
Date: Tue Aug 21, 2007 6:56 pm
Subject: Certification Process
vouglist
Offline Offline
Send Email Send Email
 
Hiya All,

If someone has recently gone through the Oracle Certification process
and is willing to share their experiences, I sure would like to hear
from you.

Drop me an e-mail directly if you have the time...

Thanks

LB.


==========================
Lawrence Blankenship '07
Hollins University
Computer Services
540-362-6487
==========================

#907 From: "vouglist" <vouglist@...>
Date: Tue Aug 21, 2007 7:40 pm
Subject: Conference Discount for VOUG Members
vouglist
Offline Offline
Send Email Send Email
 
VOUG Membership:

Advance registration is now underway for the big two-day statewide meeting in
Charlottesville this coming October 4th & 5th.  Now, the general public will be
paying $260 to attend this meeting ($320 after September 10th), but VOUG
listserv members always get an extra discount.  If you register before September
10th, the price drops to $235.  Pretty cool.

Never been to a VOUG conference before?  Then you owe it to yourself to come see
why participants consistently rate VOUG as the conference that "exceeds
expectations":
   - Personal, relaxed atmosphere
   - Top-notch presenters
   - Excellent food and beverages
   - No stampeding crowds

And you won't have to climb aboard a cross-country flight, either - it's all
right here Charlottesville, just down the road from Thomas Jefferson's
Monticello.  Plus it's a Thursday/Friday conference so you can stretch it into a
long weekend.

How To Get The Discount
-----------------------

When you fill out the conference registration form at http://www.voug.org you'll
see a field marked "VIP Passcode."  Type the word SPECIAL in that field, and
make sure you choose "VIP Passcode" in the "Registration Rate" drop-down box. 
It's that easy - but you gotta do it by September 10th!

See you in Charlottesville!

Craig Warman
VOUG Listserv Moderator

VOUG 2007
Doubletree Charlottesville Hotel
Charlottesville, VA
October 4-5, 2007
http://www.voug.org/

#906 From: "vouglist" <vouglist@...>
Date: Fri Jul 27, 2007 2:43 pm
Subject: Call For Presentations - Fall Conference - Closes Tuesday
vouglist
Offline Offline
Send Email Send Email
 
As you may've heard, a call for papers closes soon for the VOUG conference this
coming October 4-5 in Charlottesville, Virginia.  If you've ever considered
presenting at a user group conference - or, if it's been awhile and you'd like
to get back into the user group community - I'd like to encourage you to give
this one a shot.

Now, to those of you who are relative newcomers to Oracle, I would like to
encourage your participation as well.  Many times people think they have to
submit some really deep technical paper to get considered.  That is not the
case.  In fact, many attendees would really like to see presentations that cover
the basics. Things like "Here is an overview of what this product does and here
is what we had to go through to get it set up in our shop" or "Here are the top
ten things you need to know to get started with this product."

The point is, if you are working with Oracle products and have tips or advice
you're willing to give, a story to tell, or have figured out some neat way to
"get the job done" then we'd really like you consider sharing it.  One other
thing - this doesn't have to be a one-person show - you are welcome to "tag
team" with other members of your group.  That takes the burden off of you to do
it all alone, plus it's kind of fun.

Complete details about how to submit your abstract can be found at the
conference website:

http://www.voug.org/

We look forward to receiving your abstract!

Craig

PS.  One more thing - The call for papers is open until Tuesday, July 31st.  We
won't be extending that deadline, so go ahead and get your submission in this
weekend!

#905 From: "shibu_var" <shibu_var@...>
Date: Thu Jul 12, 2007 12:48 pm
Subject: Oracle financial/apps training centers
shibu_var
Offline Offline
Send Email Send Email
 
Hello folks,

Can anyone help me by giving me information on good Oracle
financial/apps training centers in Virginia. Any help would be greatly
appreciated.

Thanks

#904 From: "vouglist" <vouglist@...>
Date: Tue Jun 26, 2007 3:52 pm
Subject: Call For Presentations - Fall Conference
vouglist
Offline Offline
Send Email Send Email
 
Well the VOUG conference crew is officially back in action!  We're hard at work
preparing for our Fall conference, and it's gonna be great.  We've got the
Doubletree Hotel's meeting space reserved for us this coming October 4-5 in
Charlottesville, Virginia.

As you know, one of the very best things about our conferences (besides the food
of course) are the technical sessions.  This is where our members share their
technical knowledge and expertise with their peers.  You don't have to be some
big-name consultant to do that, either - presentations are selected based on
their technical content and relevance to the Oracle community. So if you've got
tips or advice you're willing to give, a story to tell, or have figured out some
neat way to "get the job done" then we'd like to extend an invitation for you to
share it with the group!

To submit an abstract, please visit our website at http://www.voug.org. 
Accepted speakers receive complimentary registration to the conference. The
deadline for submissions is Tuesday, July 31, 2007.

Yes, it's definitely worth your time!

Craig Warman
VOUG Listserv Moderator

#903 From: "stanorcl03" <stanorcl03@...>
Date: Mon Mar 26, 2007 4:33 pm
Subject: Recently Joined Group -- Advice on Oracle Careers in Virginia
stanorcl03
Offline Offline
Send Email Send Email
 
Hi there Virginia Oracle User's Group!

I recently joined the group and am very excited about Oracle career
opportunites in VA!  In fact I did a little research on both monster
and careerbuilder, and found that there are alot more opportunities in
VA than in any other state that I was looking to relocate to.
Currently, I am trying to complete my Oracle 10g training, and to take
my certification exams.

Just wanted to ask your advice and help:

Would you have any advice on preparing and passing the exam?
Any ideas on how I could attain some work experience during my
preparation?
Where would be the most opportunity for me after certification?
What ways can I start and develop my career as a DBA in VA?

Look forward in hearing your responses.

Thanks,

Stanley

#902 From: Bryan Jones <utefan001@...>
Date: Thu Mar 8, 2007 5:32 pm
Subject: Remote Oracle RAC Lab
vouglist
Offline Offline
Send Email Send Email
 
-- Interjection by listserv moderator:
-- I checked this out and it appears to be legit.  Even if you don't
-- need to use Bryan's hardware, the document link below is quite
-- informative.  Please contact Bryan directly (eg *don't* reply to this
-- message) if you'd like to make arrangements.

An iDevelopment.info reader (me) is now offering 3 computers that will allow you
to REMOTELY build an Oracle RAC Cluster from scratch using a VNC enabled KVM.
The cost is $14 for 7 days full access.  The $14 cost includes me helping the
user when they get stuck.

Link to Jeff Hunter's document
http://www.idevelopment.info/data/Oracle/DBA_tips/Oracle10gRAC/CLUSTER_11.shtml

Direct link to relevant section (same document)
http://www.idevelopment.info/data/Oracle/DBA_tips/Oracle10gRAC/CLUSTER_11.shtml#\
Building%20an%20Oracle%20RAC%20Cluster%20Remotely


Bryan Jones
utefan001@...
or
bryan@...

#901 From: "glshockey" <gshockey@...>
Date: Tue Mar 6, 2007 5:03 pm
Subject: Vista and 9i
glshockey
Offline Offline
Send Email Send Email
 
I realize Oracle has currenty only certified Oracle 10gr2 clinet on
Vista.  Does anyone know if Oracle 9i client will run without errors on
Vista?

Thanks.

Greg

#900 From: "conbrioenvoy" <conbrioenvoy@...>
Date: Thu Mar 1, 2007 4:10 pm
Subject: Need Oracle Installation
conbrioenvoy
Offline Offline
Send Email Send Email
 
I have a small company running an Oracle app on a hosted server.  I
have gotten some shared memory and permission errors and need to
reinstall Oracle.  Can someone provide that service?  Email directly
at steve@....  Thanks

#899 From: "Mark C. Stock" <mcstock@...>
Date: Wed Feb 14, 2007 11:16 pm
Subject: Re: Concatenating alias columnms
mcstock@...
Send Email Send Email
 
aliases cannot be referred to in the select list, or anywhere else for that
matter, except in the order by clause

but you can put your query in an in-line query and then reference the aliases in
the outer query

for instance

select .... cases_this_month || ' -- ' || dollars_this_month ....
from (
     select ...
     , brk.division division
     , SUM((NVL(rctl.quantity_invoiced,0)* NVL(msi.attribute13,1)) +
     (NVL(rctl.quantity_credited,0)* NVL(msi.attribute13,1)))
     cases_this_month
     SUM(NVL(rctl.revenue_amount,0)) dollars_this_month
     , msi.attribute12
     ... and the rest of your original query here
)

   ----- Original Message -----
   From: oamen
   To: VOUGlist@yahoogroups.com
   Sent: Wednesday, February 14, 2007 3:29 PM
   Subject: (VOUG) Concatenating alias columnms


   HI,
   I am trying to concatenate two column alises and am getting an error.
   If I use only one alias and keep the other column as it is, the
   concatenation works fine..But if I use aliases for two columns and try
   to concatenate the two, it doesn't work.
   The statement is like this...
   -----
   , brk.division division
   , SUM((NVL(rctl.quantity_invoiced,0)* NVL(msi.attribute13,1)) +
   (NVL(rctl.quantity_credited,0)* NVL(msi.attribute13,1)))
   cases_this_month
   SUM(NVL(rctl.revenue_amount,0)) dollars_this_month
   , msi.attribute12

   here I want to be able to concatenate cases_this_month and
   dollars_this_month..

   Any help would be appreciated.

   Thanks
   Asgar





[Non-text portions of this message have been removed]

#898 From: "oamen" <oamen@...>
Date: Wed Feb 14, 2007 8:29 pm
Subject: Concatenating alias columnms
oamen
Offline Offline
Send Email Send Email
 
HI,
  I am trying to concatenate two column alises and am getting an error.
If I use only one alias and keep the other column as it is, the
concatenation works fine..But if I use aliases for two columns and try
to concatenate the two, it doesn't work.
The statement is like this...
    -----
      , brk.division division
       , SUM((NVL(rctl.quantity_invoiced,0)* NVL(msi.attribute13,1)) +
           (NVL(rctl.quantity_credited,0)* NVL(msi.attribute13,1)))
cases_this_month
		   SUM(NVL(rctl.revenue_amount,0)) dollars_this_month
     , msi.attribute12


here I want to be able to concatenate cases_this_month and
dollars_this_month..

Any help would be appreciated.

Thanks
Asgar

#897 From: "vouglist" <vouglist@...>
Date: Tue Feb 13, 2007 3:58 pm
Subject: Last day to get VOUG discount for SEOUC
vouglist
Offline Offline
Send Email Send Email
 
Just a quick message to let you know that the discount to VOUG members for the
upcoming SEOUC conference ends on Thursday.  SEOUC, by the way, is taking place
in Charlotte this coming March 1st & 2nd.  Kevin Loney - bestselling author of
"Oracle Database 10g: The Complete Reference" and "Oracle Database 10g DBA
Handbook" - is the keynote, followed by two days of superb technical training:
http://www.seouc.com/presentations_abstracts.htm

Now, about the discount.  Just go to the registration form on the conference
website at http://www.seouc.com and and choose "VIP passcode" on the dropdown
registration rate menu, then enter the word SPECIAL in the "VIP Passcode" field.
That'll bring your final cost down to $220 and some change, which is a lot less
than what the general public pays.

Craig

#896 From: "vouglist" <vouglist@...>
Date: Fri Feb 2, 2007 1:22 pm
Subject: SEOUC Discounted Hotel - Last Day
vouglist
Offline Offline
Send Email Send Email
 
Folks, just a quick reminder that *today* is the last day for the
discounted $135/night room rate for SEOUC attendees at the Renaissance
Suites Hotel in Charlotte <http://www.renaissancehotels.com/CLTBR>.
You won't get that sort of price from any of the discount travel sites -
  my last check on hotels.com was $189/night.

You'll need to call them at 704.357.1414 or 800.HOTELS1 and mention the
SEOUC conference to get this discounted rate.

See you in Charlotte this coming March 1st & 2nd at the Ninth Annual
SouthEast Oracle User's Conference (SEOUC)!

Craig

#895 From: "Sherry" <sobershea@...>
Date: Wed Jan 31, 2007 7:46 pm
Subject: Multiple Inter-Company Accounts?
sobershea
Offline Offline
Send Email Send Email
 
Our 1st set of books has two companies [01,02]. The inter-company
account default on company 01 is acct 01-1367. On company 02, the
default is 02-1367.  When an entry is made in Company 01, using a
Company 02 Cost Center, the inter-company transaction is created in
the background, crediting/debiting Company 01-1367 and
debiting/crediting Company 02-1367.

We now have added a third company [03] which is in its own set of
books. So when a Company 03 Cost Center is keyed in Company 01 an
inter-company transaction should be created crediting/debiting Company
01-1370 in the 1st set of books and debiting/crediting Company 03-1370
in the 2nd set of books. Can this be done?

#894 From: "John Flack" <johnf@...>
Date: Fri Jan 19, 2007 3:10 pm
Subject: Re: Oracle Financials User Group
jcflack54
Offline Offline
Send Email Send Email
 
You want to get in touch with the Oracle Applications Users Group
(OAUG).  Find them at <a
href="http://www.oaug.com/">http://www.oaug.com/</a>.  By the way -
coming up in April is the second annual Collaborate conference, the
co-located conferences of OAUG, the Independant Oracle Users Group
(IOUG), and Quest, the users group for JD Edwards software users.
Last year in Nashville was a fine conference, and this year in Las
Vegas, building on that experience, it should be even better.

--- In VOUGlist@yahoogroups.com, "Sherry" <sobershea@...> wrote:
>
> Hello,
>
> I am looking for an Oracle Financials User Group - where the focus
is
> not the technical [i.e. setup, updates] but rather using Oracle. I
am a
> Financial Analyst with many years of Oracle use but there are still
> things that stump me. We are currently using version 11i.  For
instance,
> I have created many Rules in Oracle [setup, financials, flexfields,
key,
> rules] but am struggling with trying to make one work. It would be
great
> to find a support group!
>
> Does anyone have suggestions?
>
> Thanks in advance,
>
> Sherry
>

Messages 894 - 923 of 923   Newest  |  < Newer  |  Older >  |  Oldest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help