Where is "filter values by current value" option in Toad For Oracle 10 located?

Problem :  Where is filter values by current value option in Toad For Oracle 10 located?
In Toad For Oracle 9.7 this option is here:

1] Go to Schema Browser
2] Select a table
3] On the right hand side select the Data tab
4] Select one value in the grid
5] R-click
6] In the pop-up that appears you can select the filter values by current value

This option is no longer available in Toad For Oracle 10.

Solution : 

This option has been moved to the Filter /Sort option in the grid menu.

Please follow the steps below in order to see this option:

1] Go to Schema Browser
2] Select a table
3] On the right hand side select the Data tab
4] Select one value in the grid
5] Click on the arrow of the Filter/Sort option and select filter XXX by current value

Toad

source

Read More

ORA-39083: Object type TABLE

Problem : While importing data in oracle with impdp command, i got the following error
ORA-39083: Object type TABLE:"SECH"."SCH_DISPATCHMSG" failed to create with error:
ORA-00922: missing or invalid option
Failing sql is:

CREATE TABLE "SECH"."SCH_DISPATCHMSG" ("PK_MSG" NUMBER NOT NULL ENABLE, "MSG_SENDON" DATE, "MSG_STATUS" NUMBER, "MSG_TYPE" CHAR(2 BYTE), "FK_EVENT" NUMBER, "MSG_TEXT" VARCHAR2(4000 BYTE), "RID" NUMBER, "CREATOR" NUMBER, "LAST_MODIFIED_BY" NUMBER, "LAST_MODIFIED_DATE" DATE, "CREATED_ON" DATE DEFAULT sysdate, "IP_ADD" VARCHAR2(15 BYTE), "FK_PAT" NUMBER, "FK_SCHEVENT" CHAR(10)

Solution : The problem is fixed by adding VERSION option in impdp command as follows

DIRECTORY=<Db_directory>
DUMPFILE=CLNDB9B637.DMP
LOGFILE=<logfile>
VERSION=10.2.0.3



Adding version option solved my problem and original source where i found the solution is this

Read More