Home » SQL & PL/SQL » Client Tools » table view not avaialable for EDIT (Oracle 12.1.0.2.0)
table view not avaialable for EDIT [message #674539] Thu, 31 January 2019 22:26 Go to next message
alimlim9
Messages: 4
Registered: January 2019
Junior Member
hi,
I need edit script table view since we restore full backup rman that problem on edit script table view and the message error :

/* source of VIEW F55MAV is not available */

And when I check on dba_views or user_views record that is empty.

sqlplus : proddta@jdeora
password : xxxx

CREATE OR REPLACE VIEW PRODDTA.F55MAV AS
SELECT * FROM PRODDTA.F0101;

And we try to edit script table have error via pl/sql :
/* source of VIEW F55MAV is not available */

how to solve this case ? we have a lot of table view. need maintenace.

Re: table view not avaialable for EDIT [message #674540 is a reply to message #674539] Thu, 31 January 2019 22:53 Go to previous messageGo to next message
BlackSwan
Messages: 26640
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Prior to now I have not seen the term "edit script table view"

use COPY & PASTE show us that PRODDTA.F0101 exists.
use COPY & PASTE to show us how Oracle respond to SQL below
CREATE OR REPLACE VIEW PRODDTA.F55MAV AS SELECT * FROM PRODDTA.F0101;
Re: table view not avaialable for EDIT [message #674541 is a reply to message #674539] Fri, 01 February 2019 01:16 Go to previous messageGo to next message
Michel Cadot
Messages: 66715
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You need to tell us which tool you use, obviously it is not SQL*Plus.
You need to tell us with which user you connect to the database to do what you said, and what are its privileges.

Re: table view not avaialable for EDIT [message #674542 is a reply to message #674541] Fri, 01 February 2019 03:35 Go to previous messageGo to next message
cookiemonster
Messages: 13752
Registered: September 2008
Location: Rainy Manchester
Senior Member
If it's not in user_views then it doesn't exist in the schema you are connected as.
If it's not in dba_views then it doesn't exist at all.
Re: table view not avaialable for EDIT [message #674543 is a reply to message #674542] Fri, 01 February 2019 04:05 Go to previous messageGo to next message
alimlim9
Messages: 4
Registered: January 2019
Junior Member
my question :
if I login system
and I query select * from dba_views where owner='PRODDTA' and the record is empty , that should be have record in dba_views ?


why I can not found the record in dba_views ?

Re: table view not avaialable for EDIT [message #674544 is a reply to message #674542] Fri, 01 February 2019 04:08 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
cookiemonster wrote on Fri, 01 February 2019 09:35
If it's not in dba_views then it doesn't exist at all.
Re: table view not avaialable for EDIT [message #674545 is a reply to message #674543] Fri, 01 February 2019 04:10 Go to previous messageGo to next message
cookiemonster
Messages: 13752
Registered: September 2008
Location: Rainy Manchester
Senior Member
Does that query give 0 rows, or does it give an error?
If it gives 0 rows then there are no views in the schema PRODDTA
If it gives an error then the user you connected as doesn't have sufficient privileges to query dba_views.

Are you sure you've got the owner correct?
Re: table view not avaialable for EDIT [message #674546 is a reply to message #674543] Fri, 01 February 2019 04:13 Go to previous messageGo to next message
Michel Cadot
Messages: 66715
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
BlackSwan wrote on Fri, 01 February 2019 05:53
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read
...

My questions are:

Michel Cadot wrote on Fri, 01 February 2019 08:16

You need to tell us which tool you use, obviously it is not SQL*Plus.
You need to tell us with which user you connect to the database to do what you said, and what are its privileges.
Quote:
if I login system
and I query select * from dba_views where owner='PRODDTA' and the record is empty

1) A query does not return records but a result set makes up of rows.
2) This query CAN'T return an empty row.
3) If this query returns no rows then there is no views in this schema.

Use SQL*Plus and copy and paste your session, the WHOLE session.
Re: table view not avaialable for EDIT [message #674547 is a reply to message #674546] Fri, 01 February 2019 04:18 Go to previous messageGo to next message
alimlim9
Messages: 4
Registered: January 2019
Junior Member
i using pl/sql version : 13 and windows 2016 64 bit and oracle 12.1.0.2 standard edition.
Re: table view not avaialable for EDIT [message #674548 is a reply to message #674547] Fri, 01 February 2019 04:32 Go to previous messageGo to next message
cookiemonster
Messages: 13752
Registered: September 2008
Location: Rainy Manchester
Senior Member
pl/sql is a language, not a program.

Do you mean you are using PL/SQL Developer? That is a program.
Re: table view not avaialable for EDIT [message #674549 is a reply to message #674548] Fri, 01 February 2019 04:51 Go to previous messageGo to next message
alimlim9
Messages: 4
Registered: January 2019
Junior Member
Yes, i am using pl/sql developer version 13.
Re: table view not avaialable for EDIT [message #674550 is a reply to message #674549] Fri, 01 February 2019 05:04 Go to previous messageGo to next message
cookiemonster
Messages: 13752
Registered: September 2008
Location: Rainy Manchester
Senior Member
So that's that cleared up.

Now:
Are you sure you've connected PL/SQL developer to the correct DB?
Are you sure you've connected PL/SQL developer to the correct user?
Which user are you connecting as?
If it's not the owner of the view are you sure the user you are connecting as has permissions to view the view?

What exactly did the dba_views query return - "no rows selected" or an error?

Have you checked if the owner of the views actually exists? query dba_users (connect as sysdba using sqlplus if necessary)
Re: table view not avaialable for EDIT [message #674551 is a reply to message #674539] Fri, 01 February 2019 05:30 Go to previous messageGo to next message
John Watson
Messages: 8076
Registered: January 2010
Location: Global Village
Senior Member
It might save time if you referred to all the information already requested in your topic here,
https://community.oracle.com/thread/4197495

[Updated on: Fri, 01 February 2019 05:30]

Report message to a moderator

Re: table view not avaialable for EDIT [message #674552 is a reply to message #674551] Fri, 01 February 2019 05:44 Go to previous message
cookiemonster
Messages: 13752
Registered: September 2008
Location: Rainy Manchester
Senior Member
Hmmm - just read that thread.

@alim - I mean this in complete seriousness - Go read the oracle documentation - the introductions to SQL and PL/SQL and/or read a good text book on oracle and/or do a good online course on oracle.
You don't seem understand the basic differences between different object types, what the data dictionary is, what database links do.

You should not be messing around with RMAN restores with that little grasp of the basics. Find someone at your company who does understand the basics to locate your missing objects while you go and learn the basics.
Previous Topic: Unable to connect Oracle Database using SQL Developer
Next Topic: Blank rows in spooled txt output file using SQL developer
Goto Forum:
  


Current Time: Mon Dec 09 07:07:37 CST 2019