| 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 |
Sign in to add a comment
|
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. |
||||||||||
,
Dec 03, 2008
(No comment was entered for this change.)
Status: Accepted
Owner: halturin Labels: Milestone-Release-0.2.1 |
|||||||||||
,
Dec 20, 2008
will do later. not in the 0.2.1 there is really major refactoring.
Labels: -Milestone-Release-0.2.1
|
|||||||||||
,
Sep 17, 2009
(No comment was entered for this change.)
Labels: Milestone-Release-0.2.5
|
|||||||||||
,
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 |
|||||||||||
|
|
|||||||||||