SQL & PL/SQL :: How To Read Oracle Diagram In The Documentation
Feb 8, 2010How to read oracle diagram in the documentation?
legend etc.
ADVERTISEMENT
Forms :: Draw Diagram In Oracle Form?
Jan 27, 2012I want to draw a diagram in oracle, how do i do?
View 4 Replies View RelatedSQL & PL/SQL :: Search Documentation In Oracle With Keyword (Top-N)?
Feb 12, 2011I have questions on Top N.Before post this thread, I have read these: One select in TOP Na thread very similar with my problem
Search the documentation in Oracle with key word "Top-N", but what I mostly got is about: "Top-N Frequency Categorical Binning"
SQL> select ename, sal
2 from emp
3 where sal in
4 (
5 select distinct sal
[code]...
Actually, I am not missing parenthesis, and I can not see any syntax error.what does the issue occur?
Oracle Documentation To Migrate RAC To NON-RAC Keeping ASM
Aug 29, 2013Oracle Documentation to Migrate RAC to NON-RAC keeping ASM.
View 2 Replies View RelatedDownload Full Oracle 10gR2 Documentation?
Nov 3, 2010want to download full oracle 10gR2 documentation. I also navigated on [URL] but this link allowing me to download pdf one by one but I want to download all pdf's in single shot.
View 2 Replies View RelatedPerformance Tuning :: Oracle Documentation On Details Of AWR Report
Jun 4, 2012A coworker of mine asked if there was any documentation from Oracle that listed all of the parts of the AWR report and what each meant. I was taken back because I don't think there is. There are third party books that talk about AWR reports and their predecessor Statspack reports.
Oracle has some notes on their support site about reading an AWR or Statspack report. All I found in the official documentation was some basic information about how to run an AWR report and an overview of what it was. It would be nice to have some sort of documentation that lists out each section and explains the units and purpose.
Server Utilities :: Automatically Generate E-R Diagram
Mar 17, 2011I would like to generate automatically at a certain interval a E-R diagram with all the tables in a schema and put the file on a certain location. My problem is the word AUTOMATICALLY. Toad Data Modeller does everything I want except this.
View 11 Replies View RelatedAdding New Node Back To Cluster Via Documentation
Apr 10, 2012I have a 3 node RAC server on Windows Server 2008. Last week the hard drive went out on one of the nodes and I have had to rebuild as I could not recover anything.
I went through and deleted the old node and now I have just finished adding the new node back to my cluster via documentation. Once I created the new instance on that server DBCA attempted to start and it failed gaving me a crs error. I found out later that the other 2 nodes went down and the new one that did not start correctly was the only one up!! I went and stopped the new instance and restarted the first 2. The associated services did not start with the instance so I had to start each manually. The trace files show an ORA-29702 error with cluster group service and the instance being stopped on both of the existing nodes. No other error messages stood out.
Now I cannot get any crs services to start on that 3rd node even if I attempt to start manually. I have also tried stopping all and restarting and that does not work. I found another post on this forum from you and followed it. The ASM service was fine the entire time through all the logs and I don't know how to verify LMON in Windows but I didn't see any LMON errors in the alert log. Also, the voting disks are online. Each node has their own and they are mirrored. Where else to look?
Any Rule In Documentation When Create Partition Index?
Feb 20, 2012Is there any rule in documentation, when create partition index? For tables, it is said to partition when table is greater than 2GB, but what about index? WHat size it should have to partition?
View 1 Replies View RelatedServer Administration :: Download Patch Documentation?
Oct 27, 2011where i can download the patch documentation. Is it available in the metalink (my oracle support)? if yes then is there any other way i can get hold of it?
View 6 Replies View RelatedData Guard :: Any Documentation / Link Available To Switchover Of RAC Database Using Dgmgrl
Dec 8, 2010I am having setup of 2 node 10.2.0.4.0 RAC setup on ASM with Single Instance Physical standby on File System (OS: RHEL 5.4). I configured DG Broker without any major issues. Getting all output of 'show configuration' and all DG related logs are clear. Archives are getting transferred from both Primary nodes.
DGMGRL> show configuration
Configuration
Name: dg_rac
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
livestdby - Primary database
livedg - Physical standby database
Current status for "dg_rac":
SUCCESS
Now I am getting error Error: ORA-16535: CRS is preventing execution of a broker operation.
DGMGRL> switchover to livedg;
Performing switchover NOW, please wait...
Error: ORA-16535: CRS is preventing execution of a broker operation
Oracle Says
Quote:Cause
A broker operation was underway that required CRS to stop managing the instances of this database, but CRS management could not be stopped on behalf of the broker"s request on at least some of the instances, so the broker operation was canceled.Suspend CRS management of this database using SRVCTL STOP DATABASE -D <name> -O NONE. Then reissue the broker request.But this command is not working as it's given to stop the database.
One more thing, it's nowhere said to stop CRS while performing Switchover / Switchback using DG Broker. When we do Switchover / Switchback we keep open only one of the Primary instance.
is there any documentation / link available to switchover of RAC database using dgmgrl (DG Broker)
Client Tools :: Exporter Tool 429 Error Over And Limited Documentation?
Jul 29, 2010I converted the access db's to access 2003, the version I am running. Still, after fighting with this for a couple of days I can't get this to work and can't find information on what's wrong. I keep getting:
Error #49 - XMLExporter - ActiveX Component Can Not Create Object....Database Schema did not complete successfully.
This is really getting old. If this doesn't work is there a way to copy the tables into SQLDeveloper without the exporter tool? Like I said, I'm really at my end with this.
How To Read OCR In Oracle Rac
Dec 27, 2010my question is how to read ocr in oracle rac?
View 2 Replies View RelatedSQL & PL/SQL :: Read Only Row In Database Oracle?
Apr 25, 2012row can be marked as read only in Oracle database
View 7 Replies View RelatedSQL & PL/SQL :: Oracle Procedure To Read All The Text
Jun 12, 2013I need to modify the procedure to read all the lines of a text. Actually in my table there is a personnel number column with duplicates and a TEXT column.I need to create a procedure to read all the text per personnel number and insert it into a another table.The below code is the procedure which is reading the two lines of text field. How can I modify it to read all the text per personnel number.
create PROCEDURE hr_load_restict_text_proc
as
CURSOR cur_hr_restrict
IS
SELECT personnel_number, line
FROM hr_restriction_text_temp
[code].......
Forms :: How To Read Regedit Using Oracle 6i
Mar 12, 2012How to read regedit using oracle forms6i ?
View 6 Replies View RelatedHow To Read Outlook Mails From Oracle
Oct 3, 2012I have a number of mails every day reporting different things. I would like to load these to an oracle table and query these and have metrics depending on the results in EM. Possible to load a mail to a table? Probably clob.
View 8 Replies View RelatedForms :: How To Read Registry From Oracle
Feb 4, 2012in my case both are not working as i am using oracle forms 11g with oracle weblogic application server and attached the required .pll libraries in the form but no success yet.
find below the details;
case-1:
V_adobe_key := WIN_API_ENVIRONMENT.READ_REGISTRY('HKEY_CLASSES_ROOT'||'.PDF', '',TRUE);
when i click on the button then i does not show anything.
case-2:
V_adobe_key := CLIENT_WIN_API_ENVIRONMENT.READ_REGISTRY('HKEY_CLASSES_ROOT' || '.PDF', chr(0),TRUE);
when i click on the button form is hanged and on the server machie the following message appears " Close this form". when i close this it close the form applet session completely.
How To Create Read Only User In Oracle
Nov 16, 20131. To create a read only user who can only query the views as well as db tables and views.
2. How to create such a read-only user. 3. I have taken a full expdp backup of the production and trying to import it on the pre-production.
I use impdp
system/password table_exists_action=replace full = y dumpfile=file_name.dmp remap_schema=SYSTEM:NEW_USER remap_tablespace=SYSTEM:NEW_USER ;
This can replace and import the tables but it can't replace and add the constraints , do I have to add some other parameter in the syntax if so what it should.
Forms :: Read And Write File Using Oracle 6i?
Nov 16, 2011I have a file studnet.txt in following order
JAMs|1231|PHYSICS
SAM|1232|PHYSICS
ALI|1233|CHEMISTRY
I want to read and write data from a file in | seprated mode. file READ and WRITE using Oracle Forms6i. I have a knowledge of file handling in C++ but not use it in Oracel Form before this.
Server Utilities :: How To Read Oracle DMP File
Aug 31, 2010How do I check for the data in the DMP file.
Actually I have done some search but with no result. I have to check the oracle DMP file which is being sent through the EXP utility from oracle and have to search for a pattern in the file. If the pattern in found then send a mail.
I have tried using the GREP on the DMP and SED but as the lines are longer than expected these are not providing desired results.
PL/SQL :: Read Oracle 10g Tables To SQL Server 2012
Feb 12, 2013I have Oracle 10g on an XP machine, and use the 'Oracle in OraDB10g_home1' driver to read the data. I have another Windows Server 2008 R2 machine on the same network, with SQL Server 2012 on it. What is the best way to read Oracle Tables in SQL Server? Can I setup an ODBC link from my Windows Server machine to the Oracle Database (which would require me to download an Oracle ODBC driver)? Or is the best way to export the required tables from Oracle (e.g. into csv format) and import them into SQL?
View 1 Replies View RelatedSQL & PL/SQL :: Utl_package - Read And Load Into Oracle Data?
Mar 7, 2013I need a tutorial for using utl_file package to read and load in to oracle data.
Oracle is in Linux box.
PL/SQL :: How To Read CSV File And Insert Data Into Oracle Table
Feb 6, 2013I have a Clob file as a in parameter in my PROC. . File is comma separated.need procedure that would parse this CLOB variable and populate in oracle table .
View 6 Replies View RelatedForms :: ORACLE ERROR Unable To Read List Of Values
Sep 28, 2010We have recently shifted our database from 10G to 11G and after the intial hickups most of the thinghs have stablised. We had changed system by Alter System command so that database does not have case sensevity problem and with that all the reports from the forams have also stabilied However some of the forms are failing with the above error ORACLE ERROR Unable to read list of values
These form are running fine with users having DBA privelege. However other users this is failing.
We have also checked that with users not having DBA privelege we are able to read the data in the table within the form also. The query in the record group is very simple
"SELECT CODE,SHORTDESC FROM GENCODES WHERE CODETYPE='BS' AND CODE <> '00'"
All these forms were fine previously when database was on 10g.
Moreover there are many other fields where list of values are there and allthose are ruing fine.
I have also checked datatype and length in query as well as fields on the form
How Much Block Will Be Read From Disk When A Single Oracle Io Call Occurs
Jul 10, 2012The block size of my db(10gr2) is 8k, and the db is on the raw device file system on a aix machine.
OS block size is 512k.
How much block will be read from disk when a single oracle io call occurs? Which one is currect, 8K or 512K?
If the block size for a single io call depends on the os block size (512k), I think os block size need to be tuned for oracle block size (8k). If we use raw device file system, os level block size has no meaning?
Security :: Provide Read / Write Access To Oracle User?
Jun 2, 2011I will have to provide read/write access to an oracle user. What privileges should i grant to the user so as to enable the user to read from and write to the files?
View 2 Replies View RelatedExport/Import/SQL Loader :: Read CSV File And Load Into Oracle Table
Aug 27, 2012I want to read the csv file and load into oracle table.But I am getting file with filename_<today date> for every day. Is it possible to use single External table to read file in dynamic.
or what is the best way to do this? My oracle version 10g in windows OS.
Forms :: Read / Write In Unix From Oracle Forms Installed In Windows
Nov 24, 2011I have a requirement to read a file from windows m/c and write into Unix Server. How can i do that in Oracle forms.
I tried TEXT_IO package.But that is not allowing to access Unix path.
Read Only User
Jun 2, 2011how to create script/steps that makes database read only to a particular user
View 2 Replies View Related