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

sabsac
Follow / 2 Sep 2015 at 5:02pm / Oracle
Latest post by on 3 Sep 2015 at 8:21am

using drop C

Expand content
I have used DROP table command to table EMP in my INFO schema. But I can still see the table structure using DESC EMP command in toad.Why is this so.Is my toad misbehaving?

I have used DROP table command to table EMP in my INFO schema. But I can still see the table structure using DESC EMP command in toad.Why is this so.Is my toad misbehaving?

Unanswered 111 3 / Create an account to join the discussion.
CMT18
Follow / 1 Sep 2015 at 4:30pm / Oracle
Latest post by on 2 Sep 2015 at 6:28pm

When can a Temp Table index have ROW LOCK WAITS ?

Expand content
I have a Oracle AWR report that shows that Temp Table Indexes are having ROW LOCK WAITS. The Temp table is defined as ON COMMIT PRESERVE ROWS Question: What scenarios can a Temp Table Index have ROW...

I have a Oracle AWR report that shows that Temp Table Indexes are  having ROW LOCK WAITS.

The Temp table is defined as ON COMMIT PRESERVE ROWS

Question: What scenarios can a Temp Table Index have ROW LOCK Waits ??????

Segments by Row Lock Waits

  • % of Capture shows % of row lock waits for each top segment compared
  • with total row lock waits for all segments captured by the Snapshot
OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
ONAIR ONA_TS1 SU_WEEK_INV_BATCH   TABLE 715 26.70
ONAIR TEMP TMP_EVENT_INV_FDO_IDX   INDEX 227 8.48
ONAIR TEMP TMP_EVENT_INV_SU_DETAILS_IDX   INDEX 216 8.07
ONAIR TEMP TMP_EVENT_INVENTORY_SU_IDX   INDEX 136 5.08
ONAIR TEMP TMP_SU_EVENT_DATE_IDX   INDEX 114 4.26
Unanswered 76 1 / Create an account to join the discussion.
JesseH
Follow / 2 Sep 2015 at 1:40pm / Oracle

Execute Toad script from MS Access

Expand content
I would like to launch a toad script from MS Access. The script would call a Toad Stored procedure or SQL that would create a table. This table would be used by MS Access to create reports/pivot Tables...

I would like to launch a toad script from MS Access.  The script would call a Toad Stored procedure or SQL that would create a table.  This table would be used by MS Access to create reports/pivot Tables/etc.  Our company does not allow ODBC access to oracle whatsoever period.  My hope would be to launch a script from Access that calls a toad procedure that gets data from Oracle and creates a table on my local drive.    In summary MS Access => Toad =>Oracle.   Can this be done?   

Thanks in advance for the help

49 0 / Create an account to join the discussion.
Sagittarius04
Follow / 30 Aug 2015 at 8:17am / Oracle
Latest post by on 1 Sep 2015 at 9:45pm

Migrate data from oracle to MongoDB

Expand content
Hi guys, I want to extract data from oracle database and transfer it into MongoDB and i wish to use some programming language rather than an ETL tool. So can anyone suggest me some programming language...

Hi guys, I want to extract data from oracle database and transfer it into MongoDB and i wish to use some programming language rather than an ETL tool. So can anyone suggest me some programming language(like Python) to do this and the process of how to do it?

Requirements:

Initially i have to transfer all data from oracle and after that on a timely basis i have to transfer newly inserted rows in MongoDB.

Appreciate any king of help.

Unanswered 247 5 / Create an account to join the discussion.
omokwek
Follow / 19 Aug 2015 at 10:03am / Oracle
Latest post by on 25 Aug 2015 at 3:41pm

Log off a user

Expand content
Hi guys, how can i log off a user connected to a database. The user was previously logged on in an application that using database, but didnt shut down his system properly and now the user tries to login...

Hi guys, how can i log off a user connected to a database. The user was previously logged on in an application

that using database, but didnt shut down his system properly and now the user tries to login and his getting

and error message "this user is already logged in".

Now, how can i totally log out the user "back-end" to enable the user login access?

Thanks

Unanswered 196 3 / Create an account to join the discussion.
iz.tamira
Follow / 17 Jun 2015 at 8:26am / Oracle
Latest post by on 1 Aug 2015 at 5:47pm

How can I know who is using DB Links?

Expand content
I have many base, users and links. I need to know that who is using db links?

I have many base, users and links. I need to know that who is using db links?

Unanswered 331 3 / Create an account to join the discussion.
mdsaghi
Follow / 29 Jul 2015 at 10:38am / Oracle
Latest post by on 29 Jul 2015 at 2:26pm

dirty character for db with W8ISO8859P1 characterset

Expand content
Hi all in my db NLS_CHARACTERSET= W8ISO8859P1 . in TOAD i see dirty characters, i have created ENV_Variable with name NLS_LANG="AMERICAN_AMERICA.AR8MSWIN1256" and also i have setted this in...

Hi all in my db NLS_CHARACTERSET=W8ISO8859P1.

in TOAD i see dirty characters, i have created ENV_Variable with name NLS_LANG="AMERICAN_AMERICA.AR8MSWIN1256" and also i have setted this in WINDOWS registry,but it didn't change dirty characters. how can i solve problem? please guide me !

178 2 / Create an account to join the discussion.
dwayne.sawyer
Follow / 23 Jul 2015 at 7:44pm / Oracle

SYS* Indexes not excluded using Compare Multiple Schemas

Expand content
Hello all, While using the utility for comparing multiple schemas, I have an inclusion Option set up like this: One of my schema's however returns a differences like this: Based on the logic...

Hello all,

While using the utility for comparing multiple schemas, I have an inclusion Option set up like this:

One of my schema's however returns a differences like this:

Based on the logic of the inclusion option, shouldn't these objects be excluded?

Thanks

Unanswered 121 0 / Create an account to join the discussion.
Sasanksahu
Follow / 20 Jul 2015 at 5:07pm / Oracle

Using value of a column in first cursor in second

Expand content
FOR vll_use IN cur_vll LOOP v_item := vll_use.item; v_dest := vll_use.dest; v_aggqty := vll_use.aggsupqty; FOR sk_lir IN cur_sk_lir LOOP v_aggqty := v_aggqty - sk_lir.needqty; CASE WHEN v_aggqty >...

FOR vll_use IN cur_vll
LOOP
v_item := vll_use.item;
v_dest := vll_use.dest;
v_aggqty := vll_use.aggsupqty;

FOR sk_lir IN cur_sk_lir
LOOP
v_aggqty := v_aggqty - sk_lir.needqty;

CASE
WHEN v_aggqty > 0
THEN
UPDATE suppordersku sk
SET status = 2
WHERE sk.item = v_item
AND sk.loc = v_dest
AND sk.needarrivdate = sk_lir.needarrivdate;
DBMS_OUTPUT.PUT_LINE ('aggregate quantity is ' || v_aggqty);

WHEN v_aggqty = 0
THEN
UPDATE suppordersku sk
SET status = 2
WHERE sk.item = v_item
AND sk.loc = v_dest
AND sk.needarrivdate = sk_lir.needarrivdate;
DBMS_OUTPUT.PUT_LINE ('aggregate quantity is ' || v_aggqty);


ELSE
UPDATE suppordersku sk
SET needqty = ABS (v_aggqty)
WHERE sk.item = v_item
AND sk.loc = v_dest
AND sk.needarrivdate = sk_lir.needarrivdate;
DBMS_OUTPUT.PUT_LINE ('aggregate quantity is ' || v_aggqty);


END CASE;
END LOOP;


FOR sk_gui IN cur_sk_gui
LOOP
v_aggqty := v_aggqty - sk_gui.needqty;

How to avoid entering second loop i.e. cur_sk_gui if value of v_aggqty =0 after 1st loop??? 

Unanswered 122 0 / Create an account to join the discussion.
sam72
Follow / 13 Jul 2015 at 9:39am / Oracle
Latest post by on 16 Jul 2015 at 8:34pm

querry

Expand content
suppose there is an office id column with 10 values and having billing status of 'c','l','d','i','n' i want the querry for the count using the decode function and...

suppose there is an office id column with 10 values and having billing status of 'c','l','d','i','n' i want the querry  for the count using the decode function and the count should be equal to the office_id consumer numbers.

Unanswered 138 1 / Create an account to join the discussion.
iz.tamira
Follow / 17 Jun 2015 at 8:28am / Oracle
Latest post by on 27 Jun 2015 at 3:25pm

How can I access private db links?

Expand content
I created private db link. How to access another user that private link?

I created private db link. How to access another user that private link?

221 2 / Create an account to join the discussion.
john.ouimette
Follow / 24 Jun 2015 at 1:46pm / Oracle

TOAD12.7 bracketing

Expand content
How do I get the brackets around IF-ELSE-ENDIF, BEGIN-END, etc. that were in 12.6 to display in 12.7? Thanks. 12.6 12.7

How do I get the brackets around IF-ELSE-ENDIF, BEGIN-END, etc.  that were in 12.6 to display in 12.7?  Thanks.

12.6

12.7

Unanswered 165 0 / Create an account to join the discussion.
parthipanmurali
Follow / 16 Feb 2015 at 11:02am / Oracle
Latest post by on 18 Jun 2015 at 11:03am

oracle

Expand content
when i have start oracle 12c database using sql developer but it shows initialization or shutdown in progress . any one help me come over the error??????

when i have start oracle 12c database using sql developer but it shows initialization or shutdown in progress. any one help me come over the error??????

Unanswered 388 2 / Create an account to join the discussion.
parthipanmurali
Follow / 5 May 2015 at 7:21am / Oracle
Latest post by on 18 Jun 2015 at 11:03am

INSERT

Expand content
i need one insert query in oracle but it will insert multiple row in table. Please help me to do.

i need one insert query in oracle but it will insert multiple row in table.

Please help me to do.

Unanswered 495 5 / Create an account to join the discussion.
skashka
Follow / 14 May 2015 at 12:00pm / Oracle
Latest post by on 16 Jun 2015 at 1:18pm

how to execute procedure conatining object type as in parameter?

Expand content
create or replace procedure GETINFO(P_IDS in IDS_TABLE) is --- IDS_TABLE is a table of object type conatins id1,id2,id3 cols. begin for I in 1 .. P_IDS.COUNT LOOP DBMS_OUTPUT.PUT_LINE(P_IDS(i).ID1 || '...

create or replace
procedure GETINFO(P_IDS in IDS_TABLE) is   ---  IDS_TABLE is  a table of  object type conatins id1,id2,id3 cols.
begin
for I in 1 .. P_IDS.COUNT LOOP
DBMS_OUTPUT.PUT_LINE(P_IDS(i).ID1 || ',' || P_IDS(i).ID2 || ',' || P_IDS(i).ID3);
END LOOP;
end GETINFO;

how to execute this procedure to get the out put?

316 3 / Create an account to join the discussion.