You will no longer receive e-mail notifications from this forum.
Log-In to post
These people make Oracle great and have the most points for this month!
NOTE: This forum is for non-product questions and discussions on the Oracle database platform. Please post Toad-family product questions in their respective product forums. Thanks!
The problem is when I SPOOL in TOAD, the line feeds that are in the text field are missing in the output and those lines run together. It's like TOAD does not pass along the linefeeds. Anyone know why? Is it some option I can set in TOAD?
The starting point is that I have a table, I write lines of text to it. The text field lines are written with embedded carriage returns. I have to use SPOOL, can't use UTL_FILE. I have to use this methodology.
Example of what's in a field (when I open in Toad's grid pop up editor) This is one row (not a real expense, wish it were!):
Meals with guest DEC 01, 2012 Personal Payment 110000-32403-7022-444 Amount: $987.00 Description: Expense description. LOS ANGELES (AP) AwardsIt also looks like that when I SPOOL from a PL/SQL command line or shell. That's good. Output from TOAD different (runs together with no linefeeds) that's bad.
The problem is when I run the same SQL and spool in TOAD, the line feeds are missing and those three lines run together. It's like TOAD does not pass along the linefeeds. Anyone know why? What I can set in TOAD?
It is being written to that table like this: var1 || CHR (13) || CHR (10) || var2 || CHR (13) || CHR (10) var 3 var2 || CHR (13) || CHR (10)
Again, it works fine if I run in UNIX from SQLPLUS. It makes a nicely formatted text file.
Hi, I am using Toad for Oracle 188.8.131.52. My database is a RAC database, 10.2.0.5 with a physical standby. I use standby redo logs for real time redo apply. The "log switch frequency map" is counting both the redo log switches and the standby redo log switches. Is this a bug? I have an 11g database, not RAC, but it uses standby redo logs for data guard and the log switch frequency map shows correctly, i.e, only the redo log switches, not the standby logs.
Additionally toad does not show standby redo logs.
Thank you in advance
TOAD has a way to view queries it uses; such as display the data in table, update tables, etc. If I remember correctly there is a set of combination keys which will show the query. However, I have forgotten what that combination of keys is and I can't find it in any of the documentation. Can someone help.
trying to move an Oracle 10G production system to a new 11G system. Installed 11G on a test box, then created tablespaces and copied data/index files. then tried expdp full=y, expdp content=metadata_only, expdp content=data_only ( only get the data for the user I login as. I wouldn't think it should be that hard to get 10G to 11G...
downloaded toad in hopes it will help with this process.
I have configured a Data guard enviroment using ORACLE 11G R2 184.108.40.206.0, and we can use spotlight on oracle to connect to Oracle database.
but the spotlight on oracle cannot know the enviroment of data guard,and the tool icon of data guard is disabled.
what's the condition to activate the data guard icon?
I've downloaded Quest Error Manager Freeware v1.4.1 to implemente in my PL/SQL packages. A very brief idea found in the author's book . In the downloaded folder, there is html file and help file but these are empty. They look like this:
Is this what should I expect or there is something missing here?
In fact, I cannot use the package as numerous procedures inside, do not have documentation to know what the parameteres we need to pass to them and how to fetch their values ... etc. I'd deeply appreciate it if someone can point out where can I find the documentation/examples/reference for this package.
i am writing a plsql bubble sorting program but it is giving a error "ORA-06532: Subscript outside of limit" kindly help me to resolve it as i am new to plsqlDECLARE
temp int;type first is VARRAY(6) of integer;arr first;i integer;j integer;BEGINi:=0;j:=1;temp:=0;arr:=first(3,1,4,2,5,9);FOR i in 0..4 LOOP FOR j in 1..5 LOOP if arr(i)>arr(j) then temp:=arr(i); arr(i):=arr(j); arr(j):=temp; end if; END LOOP;END LOOP;FOR i in 0..5 LOOP dbms_output.put_line(arr(i));END LOOP;
I have two tables table A and B.
Table A have some plan information including ID and NAME of plan. PLAN_NAME is the unique value.
Table B have some rules configured for assignment of those plans and using plan Id. One plan can have many rules.
I have to compare the data in another database for same tables, but plan Id can be differ only PLAN_NAME is matching.
I am using Data Compare feature of Toad but not sure how to do this compare as I need to compare all plan rules for a PLAN_NAME...not sure if we can join in where clause while compare with Data compare featrure...or some other effective way available?
I'm trying to create an error log table that displays package name, function name, error message, and a timestamp.
EXCEPTION WHEN OTHERS THEN ERROR_MSG := SUBSTR(SQLERRM, 1, 100); INSERT INTO ERROR_LOG (PACKAGE_NAME, FUNCTION_NAME, ERROR_MESSAGE, ERROR_TIMESTAMP, USER_ID) VALUES ('USER_PKG', 'INSERT_FUNCT', ERROR_MSG, CURRENT_TIMESTAMP);
It's saying ERROR_MSG must be declared by I'm not sure how to do that
As we know ,we can create a database by method DBCA,OMF and MANUALLY, I want to know there is any another method to create a database and also I want to know what is advantage
HiI'm trying to use debug option with a procedure. But when I press execute, it shows this message "UNABLE TO FIND RAC CONNECTION INFORMATION FOR RACCELR (INST_ID=2)"I found some information and it says that Oracle doesn't support debugging accros RAC instancesWe have a RAC instances and It works without any problem. What can I do to sort it out? This is the tnsnames that i'm usingRACCELR.CLINICAROSARIO.COM.CO = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = raccelr) ) )Thank you so much por your help
Anyone have any idea what the code looks like for an amortization schedule in pl/sql? Does SQL Navigator even have a PMT function similar to excel? I like to think it would but cant seem to find it.
I am using Toad for Oracle Base 220.127.116.11.
I wish to display only certain columns from table xyz. I display table xzy, click on the column select button in the upper left area, un-select all, all become un-selected. I choose only the columns I wish to see, and then click outside the column select area. The table is re-displayed, and only the columns I wish to view are displayed.
I then wish to sort on column abc, and click on that column, select ascending or descending, and the table is redisplayed, sorted on that column, with ALL columns displayed.
It seems there is NO means to "permanently save" the selection of columns one wishes to see.
Just blink, and it all changes.
Is there a way to truly select ONLY certain columns for display ?
I have an XML document that I would like to import into a XMLType column in an Oracle table.
Is there a standard import utility to perform this function in TOAD? If not, how is this achievable?
Thanks in advance
I was in the process of configuring ASM Filter Driver (ASMFD) and it was failing with following errors.
-bash-3.2# $ORACLE_HOME/bin/asmcmd afd_configureConnected to an idle instance.AFD-620: AFD is not supported on this operating system version: '2.6.32-100.26.2.el5'ASMCMD-9524: AFD configuration failed 'ERROR: afdroot install failed'
When I googled, could not find a single match for this error.
I recalled a similar issue with ACFS as per Bug 10185375. As per the Bug description, ACFS is not supported on Unbreakable Enterprise Kernel and they did not mention a workaround too.
To verify, I have checked my OS release -bash-3.2# uname -r2.6.32-100.26.2.el5
Yes, I am using UEK.
Now, me being an impatient person; was looking for an alternative option as I was too determined to explore ASMFD.
Here, what I did.
Rebooted my Linux, went to Grub Menu, booted the system with Red Hat Compatible Kernel.
-bash-3.2# uname -r2.6.18-238.el5
Guess what!! I was able to successfully install ASMFD with a Red Hat Compatible Kernal.
-bash-3.2# $ORACLE_HOME/bin/asmcmd afd_configureConnected to an idle instance.AFD-627: AFD distribution files found.AFD-636: Installing requested AFD software.AFD-637: Loading installed AFD drivers.AFD-9321: Creating udev for AFD.AFD-9323: Creating module dependencies - this may take some time.AFD-9154: Loading 'oracleafd.ko' driver.AFD-649: Verifying AFD devices.AFD-9156: Detecting control device '/dev/oracleafd/admin'.AFD-638: AFD installation correctness verified.Modifying resource dependencies - this may take some time.ASMCMD-9524: AFD configuration failed 'ERROR: OHASD start failed'
I have ignored the error ASMCMD-9524 as it was not impacting the configuration.
-bash-3.2# $ORACLE_HOME/bin/asmcmd afd_stateConnected to an idle instance.ASMCMD-9526: The AFD state is 'LOADED' and filtering is 'DEFAULT' on host 'labserver.home.com'
Now, I shall log a SR with Oracle for this ASMFD error.