Oracle

Oracle Community

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!

Community Discussion

whippsa
Follow / 22 Jan 2015 at 7:11pm / Oracle

SPOOL output in TOAD does not pass along linefeeds.

Expand content
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...

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) Awards

It 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. 

25 0 / Create an account to join the discussion.
sam.powell71026
Follow / 14 Jan 2015 at 1:55pm / Oracle

REDO LOG SWITCHES

Expand content
Hi, I am using Toad for Oracle 12.6.0.53. 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...

Hi, I am using Toad for Oracle 12.6.0.53.  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

Sam

70 0 / Create an account to join the discussion.
RChristophel
Follow / 13 Jan 2015 at 5:40pm / Oracle
Latest post by on 13 Jan 2015 at 8:33pm

Viewing queries TOAD uses to display data on various TABS

Expand content
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...

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.

Thanks,

Roger

96 1 / Create an account to join the discussion.
jdaniel1127
Follow / 12 Jan 2015 at 1:51am / Oracle

oracle 10G to 11G

Expand content
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...

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.

Unanswered 93 0 / Create an account to join the discussion.
linuxshop
Follow / 9 Jan 2015 at 1:10pm / Oracle

How to enable the data guard Icon in spotlight on oracle 9.0

Expand content
I have configured a Data guard enviroment using ORACLE 11G R2 11.2.0.3.0, and we can use spotlight on oracle to connect to Oracle database. but the spotlight on oracle cannot know the enviroment of data...

I have configured a Data guard enviroment using ORACLE 11G R2 11.2.0.3.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?

Unanswered 95 0 / Create an account to join the discussion.
h.alzeini
Follow / 7 Jan 2015 at 1:45am / Oracle

Quest Error Manager Freeware v1.4.1 missing documentation

Expand content
Hi, 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...

Hi, 

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.

Unanswered 97 0 / Create an account to join the discussion.
jahanzaibniazi001
Follow / 26 Dec 2014 at 12:57am / Oracle
Latest post by on 29 Dec 2014 at 10:04pm

Error in PL/SQL bubble sorting program

Expand content
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 plsql DECLARE temp int; type first is...

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 plsql



DECLARE

temp int;
type first is VARRAY(6) of integer;
arr first;
i integer;
j integer;
BEGIN
i:=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;

END

184 1 / Create an account to join the discussion.
nitin.gautam
Follow / 23 Dec 2014 at 1:44am / Oracle

Compare Data with Join

Expand content
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...

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?

131 0 / Create an account to join the discussion.
tyler.beets
Follow / 5 Dec 2014 at 5:10pm / Oracle
Latest post by on 5 Dec 2014 at 8:07pm

Error Log function and exception. PLS-00201

Expand content
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...

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

172 1 / Create an account to join the discussion.
Aftab Ahmad
Follow / 21 Nov 2014 at 2:06am / Oracle

Database_Creation

Expand content
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

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

114 0 / Create an account to join the discussion.
falujar
Follow / 22 Sep 2011 at 5:34pm / Oracle
Latest post by on 19 Nov 2014 at 11:08am

Auto Debugger and trace don't work

Expand content
Hi I'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...

Hi
I'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 instances
We 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 using

RACCELR.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

1904 3 / Create an account to join the discussion.
briggsMJ
Follow / 13 Nov 2014 at 12:36pm / Oracle

Amortization Schedule Oracle PL/SQL

Expand content
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. ...

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. 

Thanks,

Mike

157 0 / Create an account to join the discussion.
detupc
Follow / 4 Sep 2014 at 8:28pm / Oracle
Latest post by on 5 Nov 2014 at 10:53pm

Column select not selected for long - how to select columns ?

Expand content
I am using Toad for Oracle Base 11.6.1.6. 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...

I am using Toad for Oracle Base 11.6.1.6.

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 ?

Unanswered 305 2 / Create an account to join the discussion.
KM1971
Follow / 31 Oct 2014 at 12:02pm / Oracle

Import XML file for Oracle XMLType Column

Expand content
Hi, 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...

Hi,

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

KM

Unanswered 182 0 / Create an account to join the discussion.
Abu Fazal Abbas
Follow / 14 Oct 2014 at 10:15am / Oracle
Latest post by on 26 Oct 2014 at 6:22pm

ASM Filter driver doesn't support Unbreakable Linux Kernel

Expand content
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_configure Connected to an idle instance. AFD-620: AFD is...

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_configure
Connected 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 -r
2.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 -r
2.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_configure
Connected 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_state
Connected 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.

 

262 2 / Create an account to join the discussion.