Oracle Data Pump imported table, some columns not selectable Imported a table into Oracle 12g using data pump. Some of the columns, though present in the table as shown by describe, cannot be selected but they show up in select *. 

Cannot select them individually  or apply where clause on only these columns.
Let me guess: when you describe the table, you see lowercase letters in column names, meaning the column name is case-sensitive, but you tried to select it without double quotes, in a case-insensitive manner.

Try quotes as in the below example:

SQL&gt; create table t1(column1 number, "column2" number);

Table created.

SQL&gt; insert into t1 values (1, 1);

1 row created.

SQL&gt; commit;

Commit complete.

SQL&gt; desc t1
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 COLUMN1                                            NUMBER
 column2                                            NUMBER

SQL&gt; select COLUMN1, column2 from t1;
select COLUMN1, column2 from t1
                *
ERROR at line 1:
ORA-00904: "COLUMN2": invalid identifier


SQL&gt; select * from t1;

   COLUMN1    column2
---------- ----------
         1          1

SQL&gt; select COLUMN1, "column2" from t1;

   COLUMN1    column2
---------- ----------
         1          1