1 PACKAGE sdo_migrate authid current_user AS
2
3 --
4 -- NAME:
5 -- to_734
6 -- DESCRIPTION:
7 -- Update an SDO 7.3.3 layer structure to a 7.3.4 layer structure.
8 -- ARGUMENTS:
9 -- sn - Schema Name of owner of layer
10 -- layer - LAYER name
11 -- tess_type - TESSellation TYPE
12 -- param - SDO_LEVEL or SDO_NUMTILES value
13 -- USAGE:
14 -- For FIXED size tessellation:
15 --
16 -- SQL> execute sdo_migrate.to_734('HERMAN','ROADS','FIXED',10)
17 --
18 -- For VARIABLE sized tessellation
19 --
20 -- SQL> execute sdo_migrate.to_734('HERMAN','ROADS','VARIABLE',4)
21 --
22 -- In each case the value of the PARAM argument is evaluated relative
23 -- to the value of the TESS_TYPE arguments. If the TESS_TYPE aregument
24 -- is FIXED then PARAM is the SDO_LEVEL values. If the TESS_TYPE
25 -- argument is VARIABLE them the PARAM value is the SDO_NUMTILES value.
26 --
27 /* deprecated
28 procedure to_734( sn varchar2,
29 layer varchar2,
30 tess_type varchar2,
31 param integer ); */
32
33 --
34 -- Migrate from 734 format to 81x object format
35 -- Index is NOT built!
36 --
37 -- The geom table and dim tables will be migrated.
38 -- layer_gtype can either be 'POINT' or 'NOTPOINT' ('NOTPOINT' by default);
39 -- update_flag can either be 'INSERT' or 'UPDATE' ('INSERT' by default);
40 --
41 procedure to_81x(layer IN varchar2,
42 newtabname IN varchar2,
43 gidcolumn IN varchar2,
44 geocolname IN varchar2,
45 layer_gtype IN varchar2 := 'NOTPOINT',
46 update_flag IN varchar2 := 'INSERT');
47
48 procedure to_current(layer IN varchar2,
49 newtabname IN varchar2,
50 gidcolumn IN varchar2,
51 geocolname IN varchar2,
52 layer_gtype IN varchar2 := 'NOTPOINT',
53 update_flag IN varchar2 := 'INSERT');
54
55 --
56 -- Migrate from 815 format to 816 object format
57 --
58 -- All geometry objects in geom table will be migrated so that
59 -- their GTYPE and ETYPE will be of 8.1.6 style.
60 --
61 procedure from_815_to_81x(tabname IN varchar2,
62 commit_int IN number := -1);
63
64 procedure to_current(tabname IN varchar2,
65 column_name IN varchar2 := NULL,
66 commit_int IN number := -1);
67 --
68 -- Migrate OGIS metadata entries in MDSYS's schema
69 -- Called at the source of migration.
70 -- This procedure will produce a temporary table called
71 -- SDO_GC_MIG that needs to be exported with other data.
72 --
73 procedure ogis_metadata_from;
74
75 --
76 -- Migrate OGIS metadata entries in MDSYS's schema
77 -- Called at the destination of migration
78 -- This call expects SDO_GC_MIG to exist.
79 --
80 procedure ogis_metadata_to;
81 function to_current(geom IN MDSYS.SDO_GEOMETRY,
82 dim IN MDSYS.SDO_DIM_ARRAY)
83 return MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE;
84
85
86 END sdo_migrate;