Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator
4 Search Results Found
1 Forum: Server Administration «» Posted on: Tue, 01 March 2016 05:29 «» By: zaff
Re: 12c Advanced Row Compression - IOT
Thanks, John. How about existing tables? I've tried the following for Advanced Row Compression: ALTER TABLE MY_IOT_TABLE MOVE ROW STORE COMPRESS ADVANCED; ALTER TABLE MY_IOT_TABLE MOVE ROW STORE COMPRESS ADVANCED * ERROR at li...
2 Forum: Spatial «» Posted on: Wed, 13 February 2013 09:26 «» By: gentleman777us
Syntax for Creating Local spatial index on Partioned table.
Iam using the following syntax to create LOCAL spatial index on partitioned table. CREATE INDEX EPLC.RESERV_P_GEOX ON EPLC.RESERVOIR (GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX [PARAMETERS('LAYER_GTYPE=POINT,TABLESPACE=EPLC_IDX')]LOCAL [(PARTITION P_NO...
3 Forum: Client Tools «» Posted on: Mon, 04 February 2013 14:09 «» By: lg123
Re: export/import schemas
I could successfully upgrade the database to 11.2.0.2, but I am not able to load the table from oracle 11.2.0.2 to oracle 11.2.0.2. I get the same errors that I got before. SQL Error: ORA-02158: invalid CREATE INDEX option 02158. 00000 - "invali...
4 Forum: Client Tools «» Posted on: Fri, 01 February 2013 15:13 «» By: lg123
Re: export/import schemas
Ok, I realize that I do not have the privilege of using datapump without the DBA privilege. I tried to export a table alone from one schema (database A) to another schema (database B). These 2 databases are oracle but belong to different versions, one is 1...

Current Time: Wed Jun 26 09:16:18 CDT 2019