1 PACKAGE DBMS_TDB IS
2 --++
3 -- Description: This function checks if a database is ready to be
4 -- transported to a target platform. If the database is not
5 -- ready to be transported and serveroutput is on, a detailed
6 -- description of the reason why the database cannot be
7 -- transported and possible ways to fix the problem will be
8 -- displayed
9 --
10 -- Inputs: target_platform - name of the target platform
11 --
12 -- Outputs: None
13 --
14 -- Returns: TRUE if the datababase is ready to be transported.
15 -- FALSE otherwise.
16 --++
17 SKIP_NONE constant number := 0;
18 SKIP_INACCESSIBLE constant number := 1;
19 SKIP_OFFLINE constant number := 2;
20 SKIP_READONLY constant number := 3;
21
22 FUNCTION check_db(
23 target_platform_name IN varchar2,
24 skip_option IN number)
25 RETURN boolean;
26
27 FUNCTION check_db(
28 target_platform_name IN varchar2)
29 RETURN boolean;
30
31 FUNCTION check_db
32 RETURN boolean;
33
34 --++
35 -- Description: This function checks if a database has external tables,
36 -- directories or BFILEs. It will use dbms_output.put_line to
37 -- output the external objects and their owners.
38 --
39 -- Inputs: None
40 --
41 -- Outputs: None
42 --
43 -- Returns: TRUE if the datababase has external tables, directories or
44 -- BFILEs. FALSE otherwise.
45 --++
46 FUNCTION check_external
47 RETURN boolean;
48
49 --++
50 -- Description: This procedure is used in transport script to throw a SQL
51 -- error so that the transport script can exit.
52 --
53 -- Inputs: should_exit - whether to exit from transport script
54 --
55 -- Outputs: None
56 --
57 -- EXCEPTIONS: ORA-9330
58 --++
59 PROCEDURE exit_transport_script(
60 should_exit IN varchar2);
61 END;