1 PACKAGE csf_spatial_ttsp_pub AUTHID CURRENT_USER AS
2 /* $Header: CSFPTTSPS.pls 120.1 2009/08/25 10:55:15 vpalle noship $ */
3
4 g_log CONSTANT NUMBER := fnd_file.LOG;
5
6 g_output CONSTANT NUMBER := fnd_file.output;
7
8 /* This procedure is called from Spatial Dataset TTSP Plugout concurrent program.
9 It drops all the objects of TTSP being plugged out.
10 Parameter :
11 p_data_set_name : Spatial data set name.
12 */
13 PROCEDURE TTSP_PLUGOUT(
14 errbuf OUT nocopy VARCHAR2,
15 retcode OUT nocopy VARCHAR2,
16 p_data_set_name IN VARCHAR2 );
17
18 /* This procedure is called from Spatial Dataset TTSP Plugin concurrent program.
19 It plugins the TTSP containg the spatial data with the help of DATAPUMP. It also imports
20 the table statistics of all spatial tables and initializes all spatial indexes in a tablespace
21 that was transported (APPS user ).
22
23 Note :
24 Initialization all spatial indexes in a tablespace that was transported for CSF user
25 can be done as follows :
26
27 Connect csf/csf pwd
28
29 and run " begin SDO_UTIL.INITIALIZE_INDEXES_FOR_TTS; end; "
30
31 Parameters :
32
33 p_directory_path : Directory path where the dump file is located. A database directory
34 'TTS_NAVTEQ_2008' for the given path and log files created at the same location.
35
36 p_dmp_file : Name of the dump file.
37
38 p_data_file_dir : Transport data files directory
39
40 p_data_file_str : List of transport datafiles separated by ','.
41
42 p_data_set_name : Spatial data set name.
43 */
44 PROCEDURE TTSP_PLUGIN(
45 errbuf OUT nocopy VARCHAR2,
46 retcode OUT nocopy VARCHAR2,
47 p_directory_path IN VARCHAR2,
48 p_dmp_file IN VARCHAR2,
49 p_data_file_dir IN VARCHAR2,
50 p_data_file_str IN VARCHAR2,
51 p_data_set_name IN VARCHAR2 ) ;
52
53 PROCEDURE DATAPUMP_EXPORT(
54 p_dmp_file IN VARCHAR2,
55 p_table_space IN VARCHAR2,
56 p_data_set_name IN VARCHAR2,
57 errbuf OUT nocopy VARCHAR2,
58 retcode OUT nocopy VARCHAR2);
59
60 PROCEDURE PREPARE_INDEXES_FOR_TTS(
61 p_table_space IN VARCHAR2,
62 errbuf OUT nocopy VARCHAR2,
63 retcode OUT nocopy VARCHAR2);
64
65 PROCEDURE EXPORT_TABLE_STATS(
66 p_data_set_name IN VARCHAR2,
67 errbuf OUT nocopy VARCHAR2,
68 retcode OUT nocopy VARCHAR2) ;
69
70 END csf_spatial_ttsp_pub;
71