My favorites | Sign in
Logo
                
New issue | Search
for
| Advanced search | Search tips
Issue 13: Can't view Tables, Indexes , Triggers in oracle 9i session because it doesnt support Recycle Bin
1 person starred this issue and may be notified of changes. Back to list
Status:  Accepted
Owner:  halturin
Type-Defect
Priority-Medium
Milestone-Release-0.2.5


Sign in to add a comment
 
Reported by vostorga, Dec 03, 2008
What steps will reproduce the problem?
1. Connect to a Oracle 9i database
2. Try to expand in "My Schema" Tables, Indexes or Triggers


What is the expected output? What do you see instead?
Expected: View list of tables, indexes or triggers

What happens: In the messages space appears:
ORA-00904:"B"."DROPPED":invalid identifier; in the case of triggers the
message is ORA-00942:Table or view does not exist

What version of the product are you using? On what operating system?
gsql 0.2.0 
Gentoo GNU/Linux kernel 2.6.26-gentoo-r3

Please provide any additional information below.

"Recycle Bin" is a feature introduced in Oracle 10g, so it is non existent
in Oracle 9i

In the case of tables, it can be solved if the query does not include the
condition:  and b.dropped='NO' because user_tables.dropped doesnt exist.

In the case of indexes it can be solved if the condition   and
b.dropped='NO'  is ommited because user_indexes.dropped does not exist

In the case of triggers it can be solved if the condition :
and b.trigger_name not in (select object_name from user_recyclebin where
object_name=b.trigger_name) 
is ommited because the table user_recyclebin does not exist.

I think this is some major rewrite because there are a few other things
using recycle bin.


Comment 1 by halturin, Dec 03, 2008
(No comment was entered for this change.)
Status: Accepted
Owner: halturin
Labels: Milestone-Release-0.2.1
Comment 2 by halturin, Dec 20, 2008
will do later. not in the 0.2.1

there is really major refactoring.
Labels: -Milestone-Release-0.2.1
Comment 3 by halturin, Sep 17, 2009
(No comment was entered for this change.)
Labels: Milestone-Release-0.2.5
Comment 4 by halturin, Sep 17, 2009
will fix it with new GSQLNavTree feature (versioned XML-storage for SQL queries).

plz, read the second message at http://groups.google.com/group/gsql-
dev/browse_thread/thread/feec69fc8f5e8b50
Sign in to add a comment

Hosted by Google Code