| Thread | Last Post | Replies |
|
| Anyone good with Joins? | 09 Apr 2008 17:23 GMT | 4 |
I'm thinking that this should be an outer join, but I am looking for some decent examples. In this query, the conditions are the same. However, the second query contains one extra table/condition/column not in the first query.
|
| RAC and scalability | 09 Apr 2008 16:35 GMT | 15 |
i've need some advise for resolve my doubt on RAC, because i have to sizing RAC environment in my business. Have been shows me two different solutions of RAC: 1) One node of Bl680c (until 4 CPU quad Core)
|
| compilation error in plsql | 09 Apr 2008 16:35 GMT | 7 |
I'm a new learner of pl/sql programing & try to write a basic function; however, I can't figure out why my function is not compiling correctly. Could someone pls let me know if you see where is the problem? This is 10g & I'm writing it using iSQL*PLUS.
|
| partitionning join table and normalization | 09 Apr 2008 16:18 GMT | 9 |
I'm working on a database which contains a big table TD (10 millions lines) with many columns (180) I wonder if the performance won t be better if i normalize some columns (about 20).
|
| Problem with a procedure | 09 Apr 2008 15:15 GMT | 8 |
I have two tables; vpd_tabell_v and USER_POLICIES. vpd_tabell_v contains all the table names that we plan to secure with VPD while the table USER_POLICIES has all the tables that have already been secured with VPD. What I am trying to do is find out in
|
| dblink_encrypt_login - obsolete in 9i or 10g? | 09 Apr 2008 13:53 GMT | 6 |
I have seen some conflicting reports for this parameter. THe 10g upgrade guide says: Initialization Parameters Obsolete in Release 10.1 The following initialization parameters were made obsolete in release
|
| migrate ORACLE TO SQL | 09 Apr 2008 12:14 GMT | 5 |
I am desperatly looking for a tool that could migrate an oracle DB (tables, PK, possibly some views triggers and SP). I am trying to migrate tables from oracle 10.2 to a MS SQL 2005. I thought oracle sql developper would do this but it migrates only from sql
|
| SELECT A CLOB - GROUP BY | 09 Apr 2008 08:53 GMT | 7 |
I am having trouble selecting a CLOB (CASE_LIST), here is what happens: SELECT PRODUCT_NAME AS "Product Name", SUM(CASES_CREATED) AS "Cases Created",
|
| DBMS_SCHEDULER JOB CLASS | 09 Apr 2008 01:44 GMT | 2 |
I created a job class specifying a service. I find that the jobs do not run when I use that job class. When I go back to the DEFAULT_JOB_CLASS, they start to run again. I don't see any errors in the alert log and since it doesn't look like it is being kicked off at
|
| Requesting Basic Info about Oracle ERP | 08 Apr 2008 21:21 GMT | 4 |
Tomorrow, I have a job interview. The company is looking for someone who has experience with "Oracle ERP". I've never used Oracle ERP, but I have used SAP, and that was good enough to get me the interview. To prepare, I'd like to learn as much as I can about Oracle ERP.
|
| Insert Question | 08 Apr 2008 20:01 GMT | 1 |
Say I have an external table with 4 columns like this. (Actual tables have more than 100 columns). C1 C2
|
| Requesting Basic Info about Oracle ERP | 08 Apr 2008 20:01 GMT | 2 |
Tomorrow, I have a job interview. The company is looking for someone who has experience with "Oracle ERP". I've never used Oracle ERP, but I have used SAP, and that was good enough to get me the interview. To prepare, I'd like to learn as much as I can about Oracle ERP.
|
| A small gig requiring you to know Oracle Model clause | 08 Apr 2008 17:32 GMT | 16 |
I have 10-12 hours gig that I need help on Model clause. Please let me know if you have available. Thanks.
|
| Turning Off Archive Logging for Dev, Test Systems | 08 Apr 2008 15:04 GMT | 5 |
We are running a few SAP/Ora9i/10g Windows systems in which point-in- time recovery is not needed. (Some of these systems can easily be rebuilt, and
|
| ASMM question | 08 Apr 2008 13:55 GMT | 7 |
sga_target_size = 4g sga_max_size = 6g When the instance starts, how much memory will it try to allocate? 6g or 4g?
|