Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
In oracle if we create an table with an index that has an indextype clause, scripting the index objects is missing the indextype clause.
Example:
CREATE TABLE "DB_LEFT"."TBL01" ("A" NUMBER(15,5) PRIMARY KEY NOT NULL , "B" VARCHAR(250) NULL) GO CREATE INDEX "DB_LEFT"."IDX_TBL01" ON "DB_LEFT"."TBL01" ("B") INDEXTYPE IS ctxsys.context parameters ('DATASTORE CTXSYS.DEFAULT_DATASTORE') GO
when scripted the INDEXTYPE is ctxsys.context & parameters is missing
CREATE TABLE "DB_LEFT"."TBL01" ("A" NUMBER(15,5) PRIMARY KEY NOT NULL , "B" VARCHAR(250) NULL, "C" VARCHAR(250) NULL) GO CREATE INDEX "DB_LEFT"."IDX_TBL01" ON "DB_LEFT"."TBL01" ("B") INDEXTYPE IS ctxsys.context NOPARALLEL parameters ('DATASTORE CTXSYS.DEFAULT_DATASTORE') GO CREATE INDEX "DB_LEFT"."IDX_TBL02" ON "DB_LEFT"."TBL01" ("C") INDEXTYPE IS ctxsys.context PARALLEL 3 GO
Issue #15106 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build v18.0.6-2, v19.0.0-dev-9 |
| No time estimate |
