OraFAQ Forum: Client Tools » table view not avaialable for EDIT

Home » SQL & PL/SQL » Client Tools » table view not avaialable for EDIT (Oracle 12.1.0.2.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

table view not avaialable for EDIT [message #674539]

Thu, 31 January 2019 22:26

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.

Report message to a moderator

Re: table view not avaialable for EDIT [message #674540 is a reply to message #674539]

Thu, 31 January 2019 22:53

BlackSwan
Messages: 26757
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;

Report message to a moderator

Re: table view not avaialable for EDIT [message #674541 is a reply to message #674539]

Fri, 01 February 2019 01:16

Michel Cadot
Messages: 67648
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.

Report message to a moderator

Re: table view not avaialable for EDIT [message #674542 is a reply to message #674541]

Fri, 01 February 2019 03:35

cookiemonster
Messages: 13895
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.

Report message to a moderator

Re: table view not avaialable for EDIT [message #674543 is a reply to message #674542]

Fri, 01 February 2019 04:05

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 ?

Report message to a moderator

Re: table view not avaialable for EDIT [message #674544 is a reply to message #674542]

Fri, 01 February 2019 04:08

gazzag
Messages: 1091
Registered: November 2010
Location: Bedwas, 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.

Report message to a moderator

Re: table view not avaialable for EDIT [message #674545 is a reply to message #674543]

Fri, 01 February 2019 04:10

cookiemonster
Messages: 13895
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?

Report message to a moderator

Re: table view not avaialable for EDIT [message #674546 is a reply to message #674543]

Fri, 01 February 2019 04:13

Michel Cadot
Messages: 67648
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.

Report message to a moderator

Re: table view not avaialable for EDIT [message #674547 is a reply to message #674546]

Fri, 01 February 2019 04:18

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.

Report message to a moderator

Re: table view not avaialable for EDIT [message #674548 is a reply to message #674547]

Fri, 01 February 2019 04:32

cookiemonster
Messages: 13895
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.

Report message to a moderator

Re: table view not avaialable for EDIT [message #674549 is a reply to message #674548]

Fri, 01 February 2019 04:51

alimlim9
Messages: 4
Registered: January 2019

Junior Member

Yes, i am using pl/sql developer version 13.

Report message to a moderator

Re: table view not avaialable for EDIT [message #674550 is a reply to message #674549]

Fri, 01 February 2019 05:04

cookiemonster
Messages: 13895
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)

Report message to a moderator

Re: table view not avaialable for EDIT [message #674551 is a reply to message #674539]

Fri, 01 February 2019 05:30

John Watson
Messages: 8458
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

cookiemonster
Messages: 13895
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.

Report message to a moderator

Previous Topic:	Unable to connect Oracle Database using SQL Developer
Next Topic:	Blank rows in spooled txt output file using SQL developer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 21 12:55:23 CST 2021