Current position:  Home > Default > Delete query not working ?

Delete query not working ?

Time:November 30
Advertisement
hi all,
this delete query is not working for me. Could you please help me and tell me ho to resolve this ? The error i get when executing this query is "ORA-00903: invalid table name". The table name is correct I fail to understand why does it show invalid table name.
Thanking you all.
Regards
Advertisement
Obviously the table name isn't correct. Either that, or the user that the query is running under doesn't have permissions to view it, so it's getting the response that the table does not exist.
Look at the user you are connecting as. Log in to sqlplus and make sure that user has select perms on the table.
Check your spelling of the table name. Typos happen.

How to collect the deleted query in a transport request.

2015-10-11

Hi Friends, I have created a query and transported it to the Quality, the data content is all ok, except that i have not used the Project Naming conventions. Now i have a defect against my name for this. I have to copy the same query with the correct

SAP BW query view deletion in Web/ "Delete Query view" in web

2015-10-11

Dear All, We are using the standard template: BW web analyzer (0ANALYZER). In this standard template, SAP provided two links "Save View" and "Open View" for creating new query views and opening existing query views respectively. Howeve

DELETE query takes long time more than 30 min

2015-10-11

Hi I have delete query as below.It takes 1300 sec to execute .Please let me know how to reduce the time of execution.I have indexes on both the columns jdoid,jdoversion of deletion. DELETE FROM SIT7016.DEVICEINTERFACE WHERE JDOID = :1 AND JDOVERSION

Delete query is taking too much time...

2015-10-11

Hi All, Below delete query is taking at least 1hrs. !!!! DELETE aux_current_link aux WHERE EXISTS ( SELECT * FROM link_trans_cons link2 WHERE aux.tr_leu_id = link2.tr_leu_id AND aux.kind_of_link = link2.kind_of_link AND link2.TYPE = 'H'); table aux_c

Delete query taking too much time

2015-10-11

Hi All, my delete query is taking too much time. around 1hr 30 min for 1.5 lac records. Though I have dropped mv log on the table & disabled all the triggers on it. Moreover deletion is based on primary key . delete from table_name where primary_key

Help!! -- DELETE query

-0001-11-30

Hi There I need your help in creating a SQL query. The situation is as follows: I have three tables in a database (Team, Entry, Athlete). They are linked as follows: TEAM          ATHLETE          ENTRY TeamID ...     AthleteID ...     EntryID Name  

How restore the deleted Query in SAP BI

-0001-11-30

Hi Experts, I deleted one Bex query unexpectedly, in that i haa lot of definations, Now i want restore the that query is there any possibulity to restore deleted query  Thanks, ChandraHi Chandra Request your BASIS team to restore the system from its

Deletion Query takes too long

-0001-11-30

I have two tables with exactly the same structure. The table 1 gets data and one procedure reads that data and inserts them into another table (table2) for processing them. I have a delete query which is taking too long to execute. The query is as fo

Delete Query takes more time

-0001-11-30

Hi, My database in 10g(10.2.0.4), I fire delete query which deletes 5 Lacs records from the table but it is taking more time to delete. My table and indexes on that table in Nologging mode, Database in Archive Log Mode. Can you please help to minize

Delete query is slow in one schema.

-0001-11-30

Hi All, I have two schemas in a database PRDPUB and TOOLSERVER . In both the schemas i have a table BP_USER_PROFILE containg same amount of data , indexes and constrains. I am using one delete query to delete 26000 records from both the table , but i

Performance problem in delete query

-0001-11-30

Hi, I have to delete nearly 900 records from a table having 10 million records. Each time I am deleting 100 of these records and calling this query from my application many times. If I increase the rownum to 1000 then I get rollback segment error due

Findout a deleted query

-0001-11-30

Hi, Is there any table or anyother way in BW to findout the deleted query details. I want to check who has deleted a particular query and which date ....etc.... Appreaciate for your help in this regard.   - BKQuery Deletion can be found only in the A

Retrieve deleted query

-0001-11-30

Hi Experts, Is there any way to retrieve a deleted query in BID? Any help will be appreciated. Rgrds, Vaishnavi.........Hello Vaishnavi,   Once the query is deleted it will be permenantly deleted. Any way just let me know how you deleted?, because wh

How to delete Query views

-0001-11-30

Hi, I have created 2 query views on a particular query in BI 7. Now we don't need those query views , so we need to delete them. How can we delete them ? 1. I tried openeing Bex analyzer and opening query, query view, right click and delete. but the

How Can I Restore Deleted Query?

-0001-11-30

Hi, gurus. Can anybody tell me How Can I Restore Deleted Query? Help me plz.If it has only been deleted from the role and not the object completely then it could still be found within infoareas in Bex, if the object has been deleted completely you co

Delete query using inner join

-0001-11-30

I need to delete records from a table using inner join from other tables. See below for the table structure and records. CREATE TABLE STUDENT (ROLL_NO NUMBER(10),NAME VARCHAR2(100),DEPT_NO NUMBER(10),JOIN_DATE DATE); CREATE TABLE DEPART (DEPT_NO NUMB

How to recover a deleted Query or Workbook

-0001-11-30

Hi All, is there any way to recover a deleted Query or Workbook? Thanks GiloHI all, Thank you for your answer. I went into table E071 but there is no filed where i can enter the query name. Even if i find the request, how to get it back? could you pl

How to retain a deleted query

2015-10-11

Hi friends,                 I accidently deleted a query which is very important , is there a way I can retain it back ? thank you.Hi CG, Ask your BASIS Guys to restore your data they will restore your data from data base table. Reward if useful Rega

How to transport a deleted query?

2015-10-11

I have deleted one query in developmeny system. I thought it will ask for tranport request.But it did not ask for any transport requast.Now it is deleted from development system.Please let me know how to transport this change in production?Hi Saikat,