Server Administration :: Unable To Drop User - Table Or View Does Not Exist

Jun 6, 2011

Im facing the problem whenever I try to drop a user. Following thing that I m trying..

system@vahan> drop user knp cascade;

Error at line 1:
ORA-00604: error occured at recursive SQL level 1
ORA-00942: table or view does not exist
ORA-06512: at line 7

View 4 Replies


ADVERTISEMENT

Server Administration :: Unable To Drop User Without Database Shutdown

Apr 19, 2013

We are unable to drop user due to below error, how to drop the below user without shutdown the database.

SQL> drop user mvm_2010 cascade;
drop user mvm_2010 cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-14452: attempt to create, alter or drop an index on temporary table already in use

No session was available for particular user.

View 19 Replies View Related

Server Administration :: ORA-00054 - Drop MATERIALIZED View Log?

Jan 17, 2013

SQL> drop MATERIALIZED view log on afccv.tbl_voicechat;
drop MATERIALIZED view log on afccv.tbl_voicechat
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

i dont want to kill the sessions or anything is there any way to set prority to do this task?

View 2 Replies View Related

Server Administration :: Precautions Before Drop User

Jul 28, 2011

I want to drop some users which are no longer been used .What are the precautions i need to take before i drop users? I have taken logical backup (Export) of users i want to drop.Is there anything i missed out before i drop user?

View 4 Replies View Related

Server Administration :: Create / Drop User / Schema In Another Oracle Database Through Apex

Jul 7, 2012

Through an Oracle Apex application I need to create/drop a user/schema in another Oracle database. i.e., create/drop user remotely using an Oracle Apex application.

View 12 Replies View Related

Server Administration :: Creating A View In User From Another User?

Nov 9, 2011

I have a strange problem when creating a view in user from another user

I have a user called "Cash_tst"

its syntax creation is

-- Create the user
create user CASH_TST
identified by ""
default tablespace CASH
temporary tablespace TEMP
profile DEFAULT
quota unlimited on cash;
-- Grant/Revoke object privileges
grant connect to CASH_TST;
grant dba to CASH_TST;
grant resource to CASH_TST;

-- Grant/Revoke system privileges
grant create any view to CASH_TST;
grant unlimited tablespace to CASH_TST;

I want to create a view

CREATE VIEW TAMER
AS SELECT *
FROM [b]AROFL[/b].RA_CUSTOMER_TRX_LINES_ALL_BEFO

"AROFL" is another user on the same database
when try to create the view "tamer" i got message of
"insufficent privilege"
although i granted "create any view" to the user "cash_tst"

View 12 Replies View Related

Server Utilities :: ORA-00942 / Table Or View Does Not Exist

Jul 22, 2004

i imported a .dmp file but i got this error:

Connected to: Oracle8i Release 8.1.6.0.0 - Production
JServer Release 8.1.6.0.0 - Production
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00023: Import views not installed, please notify your DBA
IMP-00000: Import terminated unsuccessfully

Then i run the catexp.sql using SYS user. But i still got that error.

View 20 Replies View Related

Server Administration :: Can't Install SQLT - User Unable To Login

Jan 3, 2012

From metalink: Note 215187.1...Im trying to install SQLT. The installation process ask for:

Specify optional Connect Identifier (as per Oracle Net)
Include "@" symbol, ie. @PROD
If not applicable, enter nothing and hit the "Enter" key

I have tried with SID (@TESTDB) and SERVICE NAME (@TESTDB.mydomain.local) and leaving it blank, nothing works. I cant connect as SQLTXPLAIN.

View 5 Replies View Related

Server Administration :: ORA-01019 - Unable To Allocate Memory In User

Oct 8, 2011

I have installed Oracle 10g on my PC and create a Database on it. I wanted to connect it with PL Sql Developer with the same PC but it`s not connecting. It gives the following error "ORA-01019: unable to allocate memory in the user " And some time blank error message box.

Here is system information:

OS: Winsows 7
Oracle Database 10g Express Edition
PL SQL Developer 8.0.3.1510

Login Setting

User Name: book
Password: oracle
Database: XE
Connect as: Normal

View 5 Replies View Related

Server Administration :: How To Drop A Column In Huge Table

Aug 8, 2011

I want to drop a column in a huge table which contain about 420,000,000 rows,i use the alter table drop coumn command to execute,and found it takes a long time and generate huge redo.

Is there any quickly way to drop a column in a huge table?

View 5 Replies View Related

Server Administration :: Drop A Table Moved To Recycle Bin?

Jan 6, 2012

I have a question about recyclebin.When i drop a table,the talbe will be moved to recyclebin,the name is changed to BIN$...,but the constraint built on the table aren't moved to recyclebin and their name are also BIN$...,why?

View 1 Replies View Related

SQL & PL/SQL :: Materialized View - Table Or View Does Not Exist

May 2, 2012

I have a materialized view "pro_mview",I am trying to refresh the MVIEW by using the following statement.

EXEC DBMS_MVIEW.REFRESH('pro_mview','C');

But I am getting the below error.

*
Error at line 1:
ORA-12008: error in materialized view refresh path
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2256
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2462
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2431
ORA-06512: at line 1

I am able to fetch the data from that materialized view(pro_mview).

View 3 Replies View Related

Table Or View Does Not Exist Error?

Apr 25, 2007

I created a table by doing so:

create table Playlist (Artist string, Album string, Track int, Song string, Genre string);

But I get the following error message when trying to perform a query:

SQL> select artist
2 from playlist;
from playlist
*
ERROR at line 2:
ORA-00942: table or view does not exist

I entered data in for the artist, so why doesn't it work?

View 4 Replies View Related

ORA-00942 - Table Or View Does Not Exist

May 13, 2011

I am trying to run the following code. The issue i am having is when running it in a function or procedure. (the SELECT statement works on it's own - so why doesn't it would in a procedure?)

SELECT LAST_DDL_TIME from SYS.dba_objects
WHERE object_type='TABLE'
AND OBJECT_NAME = 'CONT_ASSESSMENT'

i get an error saying "PL/SQL: ORA-00942: table or view does not exist"..I a quite new to oracle / SQL.

View 1 Replies View Related

SQL & PL/SQL :: ORA-00942 - Table View Does Not Exist

Sep 14, 2011

I am currently getting an error when I try to access a table from a different schema from my Stored Procedure:

Error: PL/SQL: ORA-00942: table or view does not exist

But when I run the relevant SQL query in SQLPLUSW it is running fine.

cursor cur_prod 3 is
4 select rep.PROD_ID,
5 rep.PROD_NM,
6 rep.PROD_SHIP_DT,
7 from GWIN.T_PROD_SEG rep;

[code]....

View 2 Replies View Related

SQL & PL/SQL :: ORA-00942 / Table Or View Does Not Exist

Sep 10, 2012

I'm trying to create a procedure but it's giving me errors:

16/3 PL/SQL: ORA-00942: table or view does not exist
4/2 PL/SQL: SQL Statement ignored
3/9 PLS-00341: declaration of cursor 'S_CUR' is incomplete or malformed
63/3 PL/SQL: Item ignored
69/33 PLS-00597: expression 'S_ARRAY' in the INTO list is of wrong type
69/3 PL/SQL: SQL Statement ignored
72/15 PL/SQL: ORA-00942: table or view does not exist
72/3 PL/SQL: SQL Statement ignored

I don't get why its giving table or view does not exists, because when I just execute the SELECT statement, it returned records. weird...

here's my procedure:

create or replace procedure proc_jrp_d_old_77a
as
cursor s_cur is
select /*+ ALL_ROWS */&vtabdate,
cd.cb_cardholder_no,
ac.user_id,

[code]....

View 6 Replies View Related

SQL & PL/SQL :: ORA-00942 - Table Or View Does Not Exist

Jun 2, 2010

I Need to develop a procedure which inserts data into a table reading from other table. I am executing a insert statement for this.

But im getting below error while compiling the procedure. Quote:Error(54,15): PL/SQL: ORA-00942: table or view does not exist

I am able to execute the insert statement independently. and also able to execute the procedure without this insert.

Created the tables and procedures in the same schema.

View 10 Replies View Related

PL/SQL :: ORA-00942 - Table Or View Does Not Exist?

Oct 15, 2012

I have written a function where I am trying to select data from a table located in a different schema. I have asked my DBA to do two things as I am getting Error(14,23): PL/SQL: ORA-00942: table or view does not exist.

a) Grant privileges.
b) Create public synonym.

When I do create the table in the schema where the function is located and compile the function it compiles.

View 4 Replies View Related

ORA-00942 / Table Or View Does Not Exist

Dec 21, 2010

what is wrong with this:

CREATE OR REPLACE PROCEDURE revoke_object_priviliges_user (
p_username IN VARCHAR2)
AS
l_username VARCHAR2 (30) := upper(p_username);
BEGIN
FOR rec IN (SELECT OWNER,TABLE_NAME,PRIVILEGE,GRANTABLE FROM dba_tab_privs WHERE GRANTEE=l_username)
LOOP
IF (rec.GRANTABLE = 'NO')

[code]....

When i execute it, i get the following errors:

6/12 PL/SQL: SQL Statement ignored
6/61 PL/SQL: ORA-00942: table or view does not exist
8/2 PL/SQL: Statement ignored
8/6 PLS-00364: loop index variable 'REC' use is invalid

View 2 Replies View Related

SQL & PL/SQL :: Unable To Truncate / Drop Table

May 13, 2011

I am trying to Truncate the table but it doesnt get truncated. When I issue the command it even doesnt throw the error. I also tried to drop the table but cant even able to drop the table. I thought table might be locked. But it allows me delete a row from the table.

I am using Oracle 11g Release 11.1.0.7.0

View 17 Replies View Related

SQL & PL/SQL :: Accessing V$mystat Gives Table Or View Does Not Exist

Jul 1, 2010

I am using the sid of v$mystat to create a unique filename in my pl/sql procedure.

I have granted access to v$mystat to the user that is accessing it from system user as:

SQL>GRANT SELECT ON V_$MYSTAT TO ar;
Grant succeeded.

SQL> commit;

Commit complete.

now when i login as user ar and do a select on v$mystat it works fine:

SQL> select sid from v$mystat WHERE ROWNUM = 1;

SID
----------
290

However, when i do the same from my PL/SQL procedure it throws an error saying :

SQL> @FILECREATE
53 /

Warning: Function created with compilation errors.

SQL> show errors
Errors for FUNCTION FILECREATE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
22/8 PL/SQL: SQL Statement ignored
22/35 PL/SQL: ORA-00942: table or view does not exist

My PL/SQL function can be found as an attachment.

View 11 Replies View Related

Client Tools :: Table Or View Does Not Exist

Mar 1, 2010

In toad 9.1.0.62 version, when i open a package in schema browser. It shows table or view doesn't exist.

But the package seems to be in valid state.

I also used other schema's to open that schema packages it opens with no problems.

View 5 Replies View Related

Forms :: ORA-00942 - Table Or View Does Not Exist

Jun 8, 2011

The form actually consists of one block that refers to a table in DB(Datablock). The functionality of the form is to run some logic and then just insert data in the table .This happens on press of a button.

The problem is when I run the form thru' Admin Id it runs successfully but when I run the form through some other user it gives me the error.

The grants on the table are Public. GRANT DELETE, INSERT, SELECT, UPDATE ON XYZ TO PUBLIC;

View 3 Replies View Related

Replication :: ORA-00942 / Table Or View Does Not Exist

Jul 28, 2008

I have two schema on the two servers for replication replication is working fine.

i export one schema to another so all the tables exists at both the sites. I am adding objects in the replication group using oracle enterprise manager console.

some of the tables added fine. but some gives me error like.

ORA-23309: object UMESH.PRODUCT_MASTER of type TABLE exists

before adding this objects in the group i do like

SQL> SELECT oname FROM DBA_REPOBJECT ;
ONAME
------------------------------
AC_ACCOUNT
AC_ACCOUNT$RP
AC_ACCOUNT$RP
AC_ACCOUNT_MASTER
AC_ACCOUNT_MASTER$RP
AC_ACCOUNT_MASTER$RP

6 rows selected.

at both the sites. when i add product_master in the group then entries becomes like

SQL> SELECT oname FROM DBA_REPOBJECT ;
ONAME
------------------------------
AC_ACCOUNT
AC_ACCOUNT$RP
AC_ACCOUNT$RP
AC_ACCOUNT_MASTER
AC_ACCOUNT_MASTER$RP
AC_ACCOUNT_MASTER$RP
PRODUCT_MASTER

7 rows selected.

but with the error in and when generate replication support.

SQL> select status,request,message,oname from dba_repcatlog;
STATUS REQUEST
-------------- -----------------------------
MESSAGE
--------------------------------------------------------------------------------
ONAME
------------------------------
ERROR CREATE_MASTER_REPOBJECT

[code]....

sometimes i got error like

ORA-00942: table or view does not exist

when use CREATE_MASTER_REPOBJECT command to create object at master definition site while the the table exists at the master site.but in the same situation other objects are working fine.

View 8 Replies View Related

SQL & PL/SQL :: Creating Trigger - Table Or View Does Not Exist

Apr 6, 2012

When i try to create a trigger , i ended up with error.

SQL> create or replace
2 TRIGGER LOGON_TRG AFTER LOGON ON DATABASE
3 BEGIN
4 INSERT
5 INTO
6 user_audit_log
7 SELECT
8 user#,

[code]....

Warning: Trigger created with compilation errors.

SQL>
SQL> show error
Errors for TRIGGER LOGON_TRG:
LINE/COL ERROR
-------- -----------------------------------------------------------
2/5 PL/SQL: SQL Statement ignored
17/17 PL/SQL: ORA-00942: table or view does not exist

The command used to resolve the error is

GRANT SELECT ON v_$session TO jack;

Jack user has sysdba privilege. My question is 'sysdba' is a super and special user which has all the privileges in database. Then why does it need SELECT privilege on v$session to user to create the trigger?

View 3 Replies View Related

SQL & PL/SQL :: ORA-00942 - Table Or View Does Not Exist Even After GRANT

Apr 22, 2011

The SELECT at the end of this script fails with "ORA-00942: table or view does not exist". I think I added proper permission via GRANT command.

create table mudd_table (
a number,
b varchar2(10)
);
create user mudd_user identified by mudd_user;
grant select, insert, update, delete on mudd_table to mudd_user;
grant create session to mudd_user;
conn mudd_user/mudd_user@quadoracle;
select * from mudd_table;

View 2 Replies View Related

PL/SQL :: In Line - Table Or View Doesn't Exist?

Jul 26, 2012

I have a SQL query with a construction like:
select a, b
from tablea
,select * from (select a as a from tableb)
where ....

The issue is that in sqldeveloper I don't get any errors and the select works fine.I use the same select in myEclipse report builder and I get an table or view doesn't exist.

View 2 Replies View Related

SQL & PL/SQL :: Create Directory - Table Or View Does Not Exist

Oct 2, 2010

I am trying to do the following-

CREATE DIRECTORY my_dir AS 'd:oraclefiles';
GRANT READ,WRITE ON my_dir TO PUBLIC;

The above throws up an error-

ORA-00942: Table or view does not exist

View 9 Replies View Related

Oracle Store Procedure - Table Or View Does Not Exist

Nov 21, 2011

I have created this store procedure:

create or replace PROCEDURE INSERT_TESTTABLE
(
PrimaryKey IN NUMBER
,One IN VARCHAR2
,Two IN VARCHAR2
,Three IN VARCHAR2
,Four IN VARCHAR2
[code].......

And I get this error: Error(15,13): PL/SQL: ORA-00942: table or view does not exist

View 1 Replies View Related

SQL & PL/SQL :: DELETE Not Working / ORA-00942 - Table Or View Does Not Exist

Mar 6, 2012

connect user1/user1@dbstring
CREATE TABLE A12
(
A1 NUMBER,
A2 DATE
)
/
GRANT SELECT,UPDATE,DELETE on A12 to USER2
/
DELETE FROM user1.A12
/
--throwing error like ORA-00942: table or view does not exist

connect user2/user2@dbstring
DELETE FROM user1.A12
/
--throwing error like ORA-00942: table or view does not exist
SELECT * FROM user1.A12
/
--no rows returned

Above scenario has happened only for 2 tables out of 1000 tables in my schema.

View 15 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved