Query Builder Not Showing all the columns

[shantanu]

Hi,

I am using the Query Builder and when I drag a table from the browser (left window) on to the drawing pane, it draws the table, but only display 2 columns in it, and they are
1. *
2. rowid

Is there something extra I need to do. I check the docs but could not find anything.

Thanks for the help.
Shantanu

 

[Marco Kalter]

That's odd. All columns + * + rowid should be displayed. Can you send me the table definition?

------------------
Marco Kalter
Allround Automations

 

[shantanu]

-- Create table
create table ARIES.ML_TABLE
(
TABLE_ID NUMBER(5) not null,
TABLE_NAME VARCHAR2(30) not null,
TABLE_DESCRIPTION VARCHAR2(4000)
)
tablespace A_FARAD_MARS_DATA_AND_INDEXES
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table ARIES.ML_TABLE
is 'This table contains list of MARS tables loaded by MARS-to-FARAD loader.';
-- Add comments to the columns
comment on column ARIES.ML_TABLE.TABLE_ID
is 'MARS table ID internally generated by FARAD.';
comment on column ARIES.ML_TABLE.TABLE_NAME
is 'MARS table name.';
comment on column ARIES.ML_TABLE.TABLE_DESCRIPTION
is 'Description';
-- Create/Recreate primary, unique and foreign key constraints
alter table ARIES.ML_TABLE
add constraint MLT_PK primary key (TABLE_ID)
using index
tablespace A_FARAD_MARS_DATA_AND_INDEXES
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);

When I select the 2 columns i.e. * and rowid and click on the tick mark, an error message ora00942: comes up saying that the table or view does not exists. Here is the query which query builder creates:

select ml_table.*,
rowid
from ml_table

 

[Marco Kalter]

It would seem that you do not have select privileges for this table. Can you verify this, and if so, obtain select privileges and try again?

------------------
Marco Kalter
Allround Automations

 

[shantanu]

I have select priveledge (actually logging in as SYSDBA), because I can right click on the table and click on Edit Data or View Data to view all the data in the table.

Thanks
Shantanu

 

[Rei]

Is there a solution? I' ve the same problem with one database.
Version 6.0.6.947 of PL/SQL Developer
Database Oracle 10.2.0.4

In the active database the result is ok!

Sincerly,
R