Does Oracle provide any best practice means of dealing with Daylight Savings Time issues for remote servers in multiple locations? If so, what are the details?...
Usually this is an issue handled by the OS ( OpenVMS, Linux, Unix, Windows, Mac, etc etc). With the "new" daylight savings law that passed in the US, ...
Dr Robert Young
rcyoung@...
Aug 9, 2005 5:23 pm
781
There may be platform differences that I'm not aware of, but for the most part, Oracle picks up its clock information from the underlying operating system. So...
Oracle 9IR2.06 I'm looking for a method to create a reproducible database clone for use within a development test lab. I used to use the Export/Import ...
Use a backup of the database and simply restore it. ================================================== gofftfln <goffd@...> wrote: Oracle 9IR2.06 I'm...
Brett Ogletree
bretto97@...
Aug 9, 2005 11:15 pm
784
I forgot to mention my environment does not allow using RMAN. Darrell...
Hi Everybody, We have data in Oracle 9i data base. Users want to pull the data in Excel spreadsheet format through web. They like to download the data into...
+ Interjection by listserv moderator: + Several helpful replies to this posting, below... ... From: "I. Michael Snyder" <i.michael.snyder@...> Ram, ...
You could still take a cold backup of the database using scripts and then restore the backup whenever you want to refresh your environment. RMAN is not the...
Brett Ogletree
bretto97@...
Aug 11, 2005 4:55 pm
788
Hiya All, Here at work, I have learned that our Oracle licensing allows us to use Discoverer - I am really interested in this product. We have (at least) 2...
Larry Blankenship
lblankenship@...
Aug 22, 2005 1:52 pm
789
Larry, Your database server is just that: a database. Oracle Application Server is Oracle's webserver-on-steroids. It is really a suite of many different...
What is the common practice of transformation when loading data in a warehouse using SQL? Is all the transforming done in the SQL Loader file or are...
+ Interjection by listserv moderator: + Several helpful replies to this posting, below... ... From: Brett Ogletree <bretto97@...> Phillip, This is a...
I am working on a conversion from Access to Oracle and there are MEMO fields in Access that I assume represent huge VARCHAR2 datatypes in Oracle ,that users...
I am working with another team that uses Oracle Designer to document their schema. I need to create a dev schema for my team to use. What kind of data...
CLOBS are a little different than other data types, in that you don't INSERT INTO them, you have to open them up, stream data in to them, and then close them....
I exported the data over in Oracle and have both tables in the schema, one table containing all the data from Access and the Oracle table itself. I did a...
Designer generates ordinary DDL scripts. The user identifies the objects for which she/he wants scripts generated, sets a few parameters, including the folder...
Dear Oracle Professional The Mid Atlantic Association of Oracle Professionals (MAOP) User Group is accepting abstracts until October 10, 2005, and we invite...
Hi friends, I would appreciate if anybody can help me. Is there any way to display the sum of a numeric field of a query (after grouping on a field) in a...
In 8i and later you can use the rollup extension to the group by clause, i.e.: select deptno, sum(sal) salaries from emp group by rollup (deptno) DEPTNO...
Paul Stallard
pstall@...
Oct 14, 2005 6:55 pm
800
In Oracle 8i/9i, what would be the reasons/ conditions where you would want to place the index in a different tablespace than the table(s) involved in the...
Dr Robert Young
rcyoung@...
Oct 20, 2005 2:17 am
801
We used to think that this was very important for performance to prevent thrashing. But this was thinking based on reason, not experimental evidence -...
+ Interjection by listserv moderator: + This is a great opportunity to help kids get started + in an IT career! If you'd like to help, please + respond to...
ROBIN R. SMITH
rrsmith@...
Oct 27, 2005 1:39 pm
803
I'm a big fan of using Standby databases for backups and cloning production db's. ... to the remote(standby site) Then all you have to do is keep the standby...
Darrell, Hi. Dana has a good idea. Archive files are easier to move than the whole enchilada (yes I keep telling the app dev team 'enchilada' is a technical...
Allen Shepard
ashepard@...
Nov 17, 2005 5:12 pm
805
Anyone have experience with Network Appliance NetApp storage products and Oracle databases? Looking for comments good or bad regarding this storage solution...
Beck Smith
bsmith@...
Nov 28, 2005 8:28 pm
806
Beck, I've worked with NetApps and it's great for failover and super fast backups. The snap hot backups took about 5 minutes to complete on about 1.5GB of...
diana vann
dvann@...
Nov 30, 2005 1:26 am
807
Well, it's been a long time coming, but the VOUG conference crew is officially back in action! We're hard at work preparing for our first conference since...
I haven't used Oracle on a Windows system in a long time.... I want to take a Solaris cron job to do a backup and do the same thing in Windows... Does anyone...
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.
