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...
Steff Gonos
steff_gonos@...
Dec 7, 2005 4:57 pm
809
Dear All, Does any one have any ideas on how can I integrate Dictation buddy sound recorded software through OLE with Oracle Forms 6i, in order to get the full...
Ahmad Abusaleh
ahmadabusaleh@...
Dec 7, 2005 4:58 pm
810
I am trying to format an Oracle Report in 6i to only show a particular field only if it is not null. I wrote the new query and joined it in the Data Model...
Steff. Hi. There are two scripts I run from a windows file against an Oracle 9i database. If you are running 8i or before then you do not need the...
Allen Shepard
ashepard@...
Dec 7, 2005 7:45 pm
812
in the layout editor, right-click on the field to bring up the short-cut menu and choose 'Conditional Formatting...' this brings up a wizard which actually...
Mark C. Stock
mcstock@...
Dec 8, 2005 2:13 pm
813
Hello Steff, You need to create a script (Batch) file and add this file in the Windows task scheduler, from the control panel. You can assign user/password. ...
Hello everyone, I am having trouble pulling data from one database to another located on two separate servers within the same network. There are both Oracle...
A couple weeks ago we announced our upcoming conference - March 1-2 2006. One of the great things about these conferences is that it gives participants an...
This message is to those of you are thinking about presenting a paper at the upcoming VOUG conference, but have some doubts about whether or not your topic is...
Many organizations set aside money every year for employee education. And, sometimes, there's a few dollars left at the end of the year that never get used....
VOUG Membership - Just a quick reminder - New Year's Eve (Saturday) is the last chance to submit a presentation for the upcoming VOUG Spring 2006 conference....
Hello All, We are using Application Server 9.04 on Windows Advance Server. When we using desformat=html or htmlcss our reports show in web brewers fine. But on...
Hello All, We are using Application Server 9.04 on Windows Advance Server. There is almost 300 users viewing these reports from Oracle Application Server (OAS)...
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.
