Job-scheduling
Job Scheduling
Sites connexes
Oracle New Downloads
Licence
Search
Global search
AdsDUPLICATE DATABASE and ORA-00235 error
Hi
I am trying to run the duplicate database command, USING an rman
catalog, but keep getting
ORA-00235: controlfile fixed table inconsistent due to concurrent
update
How come ?
this is the command I run :
rman target sys/****@timsr5 catalog rman/rman@rman auxiliary / cmdfile
duplicate.rcv
and this is my duplicate.rcv :
comp.databases.oracle.server Google Group
Oracle database administration/server topics.
3 juillet 2009 : HOT GIRLS TOP AND BOTTOM SEXY MOVIE
HOT GIRLS TOP AND BOTTOM SEXY MOVIE [link] [link]
3 juillet 2009 : Usage of double quotes
Hi All, I have an insert statement that is embedded in a PHP code. It basically inserts a JS string. We have lots of single quotes inside the string which we replace by double single quotes. It works fine, but strangely now, the dev team wants to enclose the whole string in double (...)
2 juillet 2009 : Problem installing Oracle Unbreakable Linux on HP DL160G5
Here's my situation: 1. HP DL160G5 hardware RAID configured (striped). 2. Installing Oracle Unbreakable Linux (recent version). 3. Installation not a problem and system reboots. 4. Get the following messages (approximate): USB 1-1: device not accepting address 2, error -71 ... (...)
2 juillet 2009 : Install of Oracle on 2003 now, can u upgrade to 2008 later.
Wanting to install 10G or 11 onto a windows 2003 server now with a view to upgrading to 2008 server by year end. Will I need to re install oracle if I upgrade the server? Can I get away with an OS upgrade?
1er juillet 2009 : Automatic checkpoint tuning on RAC
I recently talked about the automatic checkpoint tuning with a colleague of mine and we considered setting fast_start_mttr_target to a decent non- zero value like 300 on a RAC database. I am aware of the recommendation not to set it and the argument for that recommendation is the fact (...)
1er juillet 2009 : ASM disk to physical disk mapping
Does anyone know how to map an ASM disk that I can see in OEM to its physical drive? I have a disk that is throwing errors via my hardware diagnostic (but no errors yet in Oracle). I would like to identify it in ASM, remove it and rebalance off of it. I know and can see the exact (...)
1er juillet 2009 : Stale statistics
Hi, We have OLTP system on 10gR2 with RAC (3 nodes) with lot of active tables. Means deletes, inserts and updates. We are only gathering 1% sample statistcs. After bringing the system for couple of hours all the statistics are becoming stale. All our queries use bind varaibles and (...)
1er juillet 2009 : Determing requested parallel slaves
I'm on 10.2.0.2 EE As part of some capacity management work I'm trying to ensure I have enough parallel slaves free at certain times to run my big ETL processes without any downgrades. I determine how much I have been using from ASH - yes I know it's not perfect, but (...)
1er juillet 2009 : oracle application server 10.1.3 redirect problem
Hello! I have redirection like this : Redirect / [link] So every one how enter the page : [link] automaticly will be redirect to [link] but if i add second redirect like : Redirect /test [link] second redirect wont work. I trying to create second redirect, (...)
30 juin 2009 : Stopping a Query taking more time to execute in runtime in Oracle Forms.
Hi, In the present application one of the oracle form screen is taking long time to execute a query, user wanted an option to stop the query in between and browse the result (whatever has been fetched before stopping the query). We have tried three approach. 1. set max fetch record (...)
30 juin 2009 : Anyone using nagios?
If so what do you think about it? Are you using it only on linux systems or across multiple unix systems or ... ??? How useable is the alerting and monitoring? How long have you been using it and is it something that your IT operations area is able to work with? Thanks in (...)
29 juin 2009 : physical standby database on other platfrom??
Hello! I need to know there is any possible way to create standby database on other system platform than production database. example : prodaction is on linux and standby will be on windows Reagrds - MJ
29 juin 2009 : rman duplicate maxsize archivelog
Hi, I want to duplicate a database using rman with set until time clause. It fails on recovery because there is not enough space to hold all the archivelog needed for the recovery. Is is possible to set a maxsize for archivelog like in the recover command (recover database delelte (...)
29 juin 2009 : The Special Coupons and Offers This Week
A virtual PBX system with voicemail and Internet Fax. Try it free today. [link] A Special $10 off "moo"pon -- Just for you! [link] Dictate to your Mac [link]
27 juin 2009 : Luxury Living
Luxury Living celeberties living style you want to know This site contain information about luxury living includs (houses,cars,hotels) video and informative knowledge see it Luxury Hotels * Al Faisaliah Hotel> Saudi Arabia > Riyadh * Germany > Berlin > Hotel Adlon Kempinski * (...)
27 juin 2009 : initial value on create table/index statement
Is there a way to change the value of "inital" in "create table" or "create index" during imp? Pre-creating table is not an option here. I am taking a export dump with rows=n from production and importing it into dev/QA and since the production tables/indexes have larger values for (...)
27 juin 2009 : driving_site hint in Materialized View definition
Is there any restrinction on using DRIVING_SITE hint in materialized view definition ? It seems to be ignoring the hint and is transferring the remote EMP table data (which is huge compared to the local DEPT table) to the local server for the join. The hint works perfectly fine if I (...)
25 juin 2009 : UNDO Issue
Hi, We're receiving this message: . . importing table "DAILY_CONSENSUS_HST" IMP-00058: ORACLE error 30036 encountered ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS_1' The undo tablespace has auto extend turned on and the file system is only 50% (...)
25 juin 2009 : "How to find a job that makes you over 300K in software development"
Attention Developers At last! Here are the (long overdue) tips and tricks you've been waiting for. Check out this new contrarian special report that reveals secrets of industry's highest paid programmers - the secrets you can use to skyrocket your compensation, trade a dull, (...)
24 juin 2009 : Learn oracle reports 6i in two days
Learn oracle reports 6i in two days.. WWW.ORACLEREPORTS6I.BLOGSPOT.C OM
24 juin 2009 : Why I cannot do select on other's tables even when I have DBA privileges
I have dba privileges; My database has users user1, user2… When I enter Select * from user1.table1 I get an error table or view does not exit, I am pretty sure table1 is in user1 schema. Is only way to see contents of table1 is to logon as user1, or user1 has to explicitly (...)
24 juin 2009 : Basic Scripts for Database Administration
Has anyone come across a few scripts that would make Oracle database administration easier? For example, the following command: execSql -d=DB_NAME -f=/ora/sql/chk_tspaces.sql -a=80 -e=on_output - g=DBA The above command would run the sql file (probably using sqlplus) using the (...)
24 juin 2009 : Strange behaviour of Cramer query
OS: Solaris 5.10 Oracle: 10.2.0.2 Application: Cramer see [link] I was ask to look at a performance issue on a database used for Cramer. A stored procedure is executed which executes a couple of queries and returns some data. Like : PL/SQL procedure successfully (...)
24 juin 2009 : [Oracle 9i] Is the script is the same as the interactive mode?
Hi I need to create a script exporting the database in exactly the same way as in interactive Exp in interactive mode: $ exp database_user/****** Enter array fetch buffer size: 4096 > 30720 Export file: expdat.dmp > database.dmp (1)E(ntire database), (2)U(sers), or (3)T(ables): (...)
24 juin 2009 : Oracle reports 6i
Learn Oracle reports in 2 days...I have described fully how to develop the reports..
23 juin 2009 : Problems loading data into the database using SQL Loader.
Hi all, Database Oracle 9.2.0.8 NLS_LANG=AMERICAN_AMERICA.UTF8 NLS_CHARACTERSET UTF8 NLS_NCHAR_CHARACTERSET AL16UTF16 Server Red Hat Linux 2.6.9-67.ELsmp LANG=en_US.UTF-8 I cannot figure this one out. When I try to populate a table using SQl Loader I am getting corrupt (...)
23 juin 2009 : satr Kidrobot hoodies ed hardy star red monkey gino green global True
et Nike Shoes at Super Cheap Prices Discount Nike air jordans ([link]) Discount Nike Air Max 90 Sneakers ([link]) Discount Nike Air Max 91 Supplier ([link]) Discount Nike Air Max 95 Shoes Supplier ([link]) Discount Nike Air Max 97 Trainers (...)
23 juin 2009 : Remove dupes with CLOB columns involved
I've created a GLOBAL TEMPORARY TABLE where one of the columns stores the result of concatenating a variable (and unknown) number of VARCHAR2(100) cells. I didn't want to hit the 4,000 character limit when the source table has more than 40 rows so I created such temp column as (...)
22 juin 2009 : 400 No Host matches server name
Su di un Apache/2.0.49 di test (SUSE SLES9) il mod_jk che usavo per collegarmi al JBoss 3.2.3 locale ha improvvisamente smesso di funzionare. Su tutte le applicazioni mi da un errore 400 con messaggio "No Host matches server name ", dove FQDN è il nome del server, ovviamente valido e (...)
22 juin 2009 : share memory fragmentation
has anyone came accross a share memory fragmentation ? We have this issue sometime with a 300G SGA instance ( non RAC )
22 juin 2009 : Softwear and Games
This is a site contain very much use full informations and many games for free download and also many other links help you to other free downlod see this Its contain free software and games Business Software * Accounting & Billing Software * Auction Software * Business (...)
20 juin 2009 : medicine
This site contain usefull informations about medical diseases ,medicine and includs usefull links see it Medical Institutions * Howard Hughes Medical Institute * Johns Hopkins Medical Institutions * PAKISTAN JOURNAL OF MEDICAL SCIENCES For more details (...)
20 juin 2009 : RAC: typical time to reboot a node and have it rejoin the cluster?
What's a reasonable time for a rebooted RAC node to join a cluster? If you have a RAC, how long does it usually take for you? Is 5 minutes a "reasonable" number? I realize this is a very open ended question with a very broad range of possible answers, I'm just looking to get an (...)
20 juin 2009 : Atom inside: Intel announces ultramobile processor brand
Intel announced the new brand under which it will market its low-power Silverthorne and Diamondville CPUs. Both will be offered under the Intel Atom brand, with a further "Centrino Atom" title available for manufacturers who meet certain specifications. for more info visit (...)
20 juin 2009 : Mlatestlaptop.blogspot.com
Hi get information about latest laptop and pc and also free download latest games software and beautifull screen saver and get more fun,,,,,,,,,,,,,GOD bless u
20 juin 2009 : oracle jobs
oracle jobs [link] oracle jobs [link]
19 juin 2009 : non Oracle cluster resources
All, a) Can we use CRS( CLuster Ready Services) to manage non Oracle cluster resources? b) we have oracle client installed in a cluster which is currently managed by VCS, can we use CRS to replace VCS?
19 juin 2009 : Airlines
Site contain very much information about airlines inclouds coutry wise airlines companies informations and video see this for more details [link]
19 juin 2009 : Re: All SQL QUERYES WITH DEFINATION
kash schreef: Your side is bad, full of errors (both spelling and technical) and adds NO VALUE to this community. You are just fishing for Google Ads Clicks! Shakespeare
19 juin 2009 : problem with listener
Hi, I was having some problems with DNS and I had to restart listener. And from that time, database (10.2.0.4) can not register to default listener. Listener is running from different oracle_home (11g) on port 1521 and everything looks fine. Local_listener parameter in db is not set. (...)
19 juin 2009 : The VUE, Downtown Orlando's
Top class living houses and places,cars,hotels for more details [link]
19 juin 2009 : create table space for media(mp3) files
Hello! I need to know there is any special function when creating new tablespace for table that will be hold mp3 files? Regards -MJ
18 juin 2009 : Oracle Enterprise Linux installation problem
Hello, I followed instructions in [link]. After clicking on "next" in step 5, I got the following error message: "Could not allocate requested partitions: Partitioning failed: Could not allocate partitions as primary (...)
18 juin 2009 : Accesses News Group
I just received an email informing me that my internet provider is not going to support newsgroups starting the middle of next month though they said some would be "for a fee". I think these groups can also be accessed from the web but I'm not familiar with the URL. Can anybody (...)
17 juin 2009 : Issue with Oracle install on Virtual machine
Folks, Need some quick help in resolving the issue with Oracle 10g r2 install on a virtual machine ( vmware). Its goes pretty smooth until we run into Enterprise manager install step. Below is the error message.. SEVERE: Error starting Database Control Refer to the log file at (...)
17 juin 2009 : So Many Ways of Online Earning
[link] [link] [link] [link] [link] [link]
17 juin 2009 : Q: Using less space for XE install?
Hello I am installing XE. It says it needs 1.5 gigs of space. I know from running the install some time ago on another computer that almost all that space is actually the data files, not the application itself, and I can't imagine requring even a tenth of that space for my data so I (...)
16 juin 2009 : Mlatestlaptop.blogspot.com
Hi get information about latest laptop and pc and also free download latest software games and beautifull screen savar ,,,,,, and many more ,,,, get some fun......... God bless u
16 juin 2009 : oracle 11g web service question
I am looking into migrating to Oracle 11g. I am currently using Oracle 9.2.0.8 and use utl_http to call a Web Service (developed in Microsoft .NET outside of Oracle). I have not developed a Web Service; I simply call this Web Service from a PL/SQL block using utl_http calls. Will my (...)
16 juin 2009 : Oracle 11g Secure Lob Licensing Question
I read following link: [link] It shows under LOB (large object) support that it is part of Enterprise Edition without any options - Advanced Compresison) but then under SecureFiles it says it needs Advanaced Compresison (...)
16 juin 2009 : The Newest Special Offers/Discount/Coupons This Week
Save 20% on powerspeaK12 Online Foreign Language Programs for the Summer [link] Luxury Kitchen & Bathroom Fixtures [link]
16 juin 2009 : Debug ORA-03113 on Oracle XE
I have a web application written in PHP that's failing on one computer (and only that computer): a laptop that runs the Oracle 10g Express Edition. It fails when it executes a specific SELECT query: I get a "ORA-03113 end-of-file on communication channel" error and the connection (...)
15 juin 2009 : oracle notes
oracle basic information 1 [link] oracle information 2 [link] oracle information 3 [link] orcle information 4 [link]
15 juin 2009 : same sequence as primary key in more than one table
Hello, For example, I have 'sellers' and 'buyers' both need to authenticate from a database table 'users' with sequence as primary key which is also as primary key in tables 'sellers' and 'buyers' (both have one-to- one relationship with (...)
15 juin 2009 : Application and Database Connection pooling
Dear All, We have a J2EE app and are considering the connection pooling options from the Oracle 10g R2 and the J2EE app itself. I've come across posts which warn against using this feature on the application side and letting the connection pool to be managed from the Oracle end only (...)
15 juin 2009 : Re: Fastunload utilit for oracle - Unloading a huge table(partitioned) to a file - concatenating columns
On Sun, 14 Jun 2009 07:26:57 -0700 (PDT), poojam Are you sure you actually did search at all? I Googled and came up with [link] without problem. Please stop dumping your 'very very very urgent' work in a forum of volunteers if you are not prepared to do anything to resolve (...)
15 juin 2009 : Mix Oracle(OLAP, Data Mining-SVM) and Ruby With ETF Price Data
Hello, I just wrote up some notes about my efforts to use Data Mining-SVM to pick optimal times for an ETF trader to act in the market. [link] The only attributes I fed to SVM were slopes of moving averages of ETF prices. Result: SVM did not find slopes of moving averages of ETF (...)
13 juin 2009 : Indexes
This is a concept that I'm trying to grasp. It happened to us as we had a corrupted index that was throwing an ORA-600 and the index needed to be rebuilt. The index was tied to a primary key. Rebuilding the index did not help. So, I decided to drop the index and rebuild it. But it (...)
13 juin 2009 : paypal payment)(www.niketrade08.cn paypal wholesale Prada
(paypal payment)([link] paypal wholesale Prada (paypal payment)([link] paypal wholesale Puma (paypal payment)([link] paypal wholesale Sand (paypal payment)([link] paypal wholesale Shox (paypal payment)([link] paypal wholesale soccer (paypal payment)([link] paypal wholesale (...)
13 juin 2009 : paypal payment)( www.niketrade08.cn ) cheap ADIDAS jeans wholesale
(paypal payment)( [link] ) cheap EVISU jeans wholesale (paypal payment)( [link] ) cheap ED hardy jeans wholesale (paypal payment)( [link] ) cheap COOGI jeans wholesale (paypal payment)( [link] ) cheap GINO GREEN GLOBAL jeans wholesale (paypal payment)( [link] ) cheap LACOSTE jeans (...)
13 juin 2009 : about setting connection to local database from EM DBControl configure program through IPC
hi, I'm new in oralce world. I tried to setup Oracle EM DB Control. it seems I had problem to connect to local database by TCP...so I set IPC in my tnsnames.ora, and I could tnsping my service name, and I could sqlplus to connect to my local database by IPC. I hope EM DB control (...)
12 juin 2009 : Nested Materialized View Refresh
Hi I have the following nested materialized view (MV based on another MV)...... SERVER1 --------------- create table TEST (a number(5) primary key not null, b varchar2(30)) SERVER2 ---------------- create materialized view TEST_MV1 refresh complete on demand with primary key (...)
12 juin 2009 : I installed Oracle 11g in my home PC. I am trying to open the Oracle SQL developer. It's asking for Java.exe file. (Enter the full pathname for java.exe ) What I need to do? Please advice.
Hi, I am new to Oracle. I installed Oracle 11g in my home PC. I am trying to open the Oracle SQL developer. It's asking for Java.exe file. (Enter the full pathname for java.exe ) What I need to do? Please advice. Thanks, (...)
12 juin 2009 : Special Characters in Tables and Views
Greetings All, Just wondering about the significance of table names and views with a dollar sign $. Is there a special case in where you would want to build a table with a '$' Sorry if this seems elementary, I tried to find the answer on metalink and online but to no avail. (...)
12 juin 2009 : Script to run the broken job
Anyone has a readily availiable script to capture the broken job id and run it again. Thanks, Naga
11 juin 2009 : Table differences
I'm sure there is a way to do this. Have not found it yet. But, I have 2 tables, different structures. Both have a date column. I want to get the rows from table A which do not exist in table B, based on the date: TABLE A: COL1, DATE_COL TABLE B: COL1, COL2, COL3, DATE_COL I (...)
11 juin 2009 : EM creation hangs on OEL 5.3
Hi, I wonder if anyone can give some pointers as to how to resolve this issue we are experiencing. We are creating databases for various environment on our Oracle Enterprise Linux 5.3. The kernel parameters are set as per Oracle's recommendations: $ cat /etc/sysctl.conf (...)
11 juin 2009 : Oracle Stat DBA---------------NYC-----------18 Months
Position: Oracle Stat DBA Location: NYC Duration: 18 Months NOTE: CANDIDATES WHO DO NOT MEET ALL MANDATORY REQUIREMENTS WILL NOT BE CONSIDERED FOR FURTHER EVALUATION 1. A minimum of 7 years Oracle Apps 11i (Financials) DBA experience; 2. A minimum 6 years of experience in Oracle (...)
10 juin 2009 : popular hublot watches,fashion hublot watches http://www.bestcopywatch.com
2009 Fashion Hublot Watches Collection - Hublot Watch Discount Watches Collection : [link] Hublot Watches Collection : [link] Hublot was born out of a desire to transcend contemporary watch design and produce a unique watch line. Hublot fitted with the first (...)
10 juin 2009 : Buffer Busy wait event
All, All, We noticed in 20 Mins duration statspack report( Oracle 9.2.0.6) Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 11,147.18 16,392.91 Logical reads: (...)
10 juin 2009 : Interesting addition in 11G
Once upon a midnight dreary, while I pondered weak and waery, I was browsing the SQL reference, looking for something about the ALTER SYSTEM command when I suddenly looked at the "KILL SESSION" option: [link] Now, everybody knows what alter system kill session does: ALTER SYSTEM KILL (...)
10 juin 2009 : VCS/VxFS Vs ASM/CRS
Hi All, We ar at Oracle 9.2.0.6 ( 02 Node RAC) VCS,VXFs 4.1 HP Ux 11.23 and aiming Oracle 10.2.0.4 CRS replacing VCS,VxFS Could you please provide the details on CRS. Questions 1. Do we need ASM also as that will be the replacement for VxVM? 2. Licensing cost etc ( extra (...)
10 juin 2009 : cursor loop and continue statement : unexpected behaviour
Hi all, I might be overlooking something due to deadline stress. But this behaviour amazes me. It looks as if the cursor caches 100 rows and the continue statement flushes the cache and begins with the first record of a new cache fetch. I narrowed it down to the following script: (...)
10 juin 2009 : Calculating Average Row Length in Oracle 10g
All, We can get this by analyzing the tables in a schema and looking at the column avg_row_len. But, is there a sql so that I can calculate manually. In out environment, we gather statistics once and use them all the time. Thanks, (...)
10 juin 2009 : Deferred contraints - DDL
Hi, following on from the thread earlier about deferred constraints. We are on 10gR2. I was not aware of the feature and have realised this could be very useful for us for some data-load type activities. As I understand it, in order to be able to alter the sesion and make constrainst (...)
9 juin 2009 : Initially deferred constraints
Can anyone explain to me when a constraint can be deferred, but not initially deferred? My understanding is that initially deferred does not do its check until the close of a transaction, but I am not sure what NOT initially deferred means. (...)
8 juin 2009 : ORA-1691, yet a few bytes are written in the LOB of the table
Hi, For a little more than 24 hours we've been having - "ORA-1691: unable to extend lobsegment XX by 64 intablespace - ..." in our alert log file (tablespace autoextend clause has been modified now), but we noticed that in this table the insert statements that took place after (...)
8 juin 2009 : Embed a string in a string
Hi, I have a stored procedure that builds a query string as it goes through its code. So I pass in a where statement as a long string with a few criteria in it. Then I build some temporary tables and build other parts of the where statement as I go along. At one point I need to build (...)
8 juin 2009 : Luxuriescars
Do you want to know about luxuries cars? i think it is easy to you people to get information about luxuries cars. for more info visit [link]
8 juin 2009 : JOB_ID in V$SCHEDULER_RUNNING_JOBS = OBJECT_ID in DBA_OBJECTS
I was just awaken by the system administrator who was, in turn, awaken by a nagios beep about the CPU that was running amok on one of my database servers. The "top" command (platform is 10.2.0.4 on RH EL 4.2/ x86-64) identified the process as J003 and V$SCHEDULER_RUNNING_JOBS gave me (...)
8 juin 2009 : oracle apex
Hello! I need to create to items "select list" but when i choice filde in first select list item then need to creste select with clause where in second select list item depend from what i take in first select item. So in shortcut - when i chice in 1 select then i will be able do choice (...)
8 juin 2009 : Question about redo size in dump file and view
Hi Friends, I have a question about redo size generated by insert statement. Here I want to get redo size of insert/update statement, but the size from redo dump is different from view. Below is my test case. 1. create test table create table t4 ( a number) tablespace users; 2. (...)
8 juin 2009 : cheap new style coogi men t-shirts for 2009.
welcome to visit our website [link] to shop more cheap name brand clothing on-line. We’ll provide the fast shiping for you by express mail. Hope to eastblish a long-term cooperation with you in the near future.
8 juin 2009 : Anyone know RMAN?
Hi, Hope someone can help us. Been all over and cannot find the answer. We are running 10G R2. We just set up RMAN on a new database. We are already running RMAN on a different database and all is good. After a backup on the new database we get this: "specification does not match (...)
6 juin 2009 : ENTERTAINMENT LIFE
HELLO, Do u know about the SHILPA SHEETY hot news if u want to watch this so clix this web [link]
5 juin 2009 : Rumour is 11.2 out or at least announced on Sept 1 2009
You saw it first on cdos ... Wonder if 11.1.0.8 patchset also comes out then?
5 juin 2009 : Version blues
Oracle and HP have recently performed some benchmark testing of blade server RAC, in combination with Exadata storage servers. The combination, of course, topped the chart, as can be seen here: [link] The funy thing here is that the database used was Oracle RDBMS 11g RELEASE (...)
5 juin 2009 : Apologies to Oracle Corp.
It seems that I owe an apology to the Oracle Corp., their ODBC driver works fine: [mgogala@centos trace]$ /usr/local/bin/isql -v OracleODBC-11g scott/tiger +----------------------------- ----------+ +----------------------------- ----------+ SQL> select * from emp; (...)
5 juin 2009 : How to set module name in oci
hi all, My oracle version is 9i. there is not OCI_ATTR_MODULE in oci.h. how to set module name? thanks.
5 juin 2009 : Solaris x86 & Oracle
I am following Oracle patches for Solaris x86. Oracle 10g is being barely touched while patches for Oracle 11g (32 bit version) are starting to show up regularly. There is 11.1.0.7 for Solaris x86, there is even CPU APR '09 for it. Now, the question: given the low quality of Linux (...)
5 juin 2009 : pl/sql conditional cursor?
hi, Oracle 10g. In a procedure I have some code like declare cursor c1 is select x,y from tab1,tab2 where and and ; begin for r1 in c1 loop end loop; end; Now I want to turn condition 3 on/off depending on one of the procedure's parameters - without having (...)
5 juin 2009 : ORA-01090: shutdown in progress - connection is not permitted
Hi After command shutdown immediate in sqlplus on database Oracle9i I look error message: SQL> ORA-24324: service handle not initialized ORA-24323: value not allowed ORA-01090: shutdown in progress - connection is not permitted SQL> Disconnected But in Enterprise Manager database (...)
5 juin 2009 : manual dbms_mv.refresh taking longer than scheduled
All, Our manual refresh taking much longer than scheduled refresh through dba_jobs. Why is this behaviour? We are using 10gR2 with RAC with three nodes. We cannot use fast refresh because, our DBA don't want to turn on the logs and we have the following in our queries: - start (...)
5 juin 2009 : Oracle configuration related weird behaviour?
I want to replicate some schemas from a Oracle 9.2.0.8 to a 9.2.0.1. The export/import process was OK and now I've objects replicated and data loaded. A function is not working properly, and an example of what's the problem can be reproduced with this example: declare cursor (...)
4 juin 2009 : How to select a random row from each sub table after "group by"?
After "group by", the big table is grouped into many sub tables. I want to select a random row from each sub table. That's what I want. How can I realize/implement it?
4 juin 2009 : FreeTDS & Oracle11g
I have properly configured UnixODBC which used to work with Oracle10.2.0.4 and hsodbc: mgogala@centos ~]$ isql -v mstest ccmview ccmview +----------------------------- ----------+ +----------------------------- ----------+ SQL> select table_name from information_schema.tables; (...)
3 juin 2009 : Refresh Materialized view manually
Hi, We have a materialized view which was scheduled through dbms_jobs. At the same time, we want to have capability to refresh manually when some event happens. Is is it possible to do this? Do we have any issues with this? We are on 10gR2 RAC with three nodes. Your input will be (...)
2 juin 2009 : How to remove out-of-the-box policy violation from Database Control
Hi, I just installed a new Oracle 11g box with a new database created using DBCA with all the out-of-box settings. Using database control, I can see a lot of "policy violation" warning etcs. For example, one warning is "Control File Permission (Windows)". Apparently, it is complaining (...)
2 juin 2009 : oracle database 10g and odbc to mssql 2005
Hello! Any idea??? Free ODBC driver for linux ?? Need create database link to mssql 2005. Regards -MJ
1er juin 2009 : Marinzo online community
Dear all, Now you can join Marinzo.com, it’s a new online community where you can find new friends, dating, lovers, and partners. Join marinzo.com to be one of its pioneers, it is new and can be customized due to your preferences, join now and feel free to give your feedback in (...)