Rem
Rem $Header: sdortcvt.sql 08-apr-2008.15:37:31 cfreiwal Exp $
Rem
Rem sdortcvt.sql
Rem
Rem Copyright (c) 2008, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      sdortcvt.sql - Routeserer Create Version Table
Rem
Rem    DESCRIPTION
Rem      Creates the Routeservers data version table for version 11 
Rem	 data that was not created with version 11 partitioning code
Rem	 that would normally create this table.
Rem
Rem    NOTES
Rem     This should only be used for sites that have 11g data that was 
Rem     partitioned using pre-versioning partition code.
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    cfreiwal    04/08/08 - Handle table not found during DROP
Rem    cfreiwal    02/22/08 - Created
Rem

declare
begin
    execute immediate 'DROP TABLE SDO_ROUTER_DATA_VERSION';
exception when others then null;
end;
/  

CREATE TABLE SDO_ROUTER_DATA_VERSION(data_version VARCHAR2(32));
INSERT INTO SDO_ROUTER_DATA_VERSION VALUES ('11.2.0.0.0');
COMMIT;