| General Information |
| Purpose |
The DBMS_TDB package serves two purposes:
- Confirms support of transporting a database from a given
source platform to a given target platform
- Determining whether a database to be transported has been properly prepared for
transport, and if not, identifyies the condition that prevents database transport
|
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsplts.sql |
| Constants |
| Name |
Data
Type |
Value |
| SKIP_NONE |
NUMBER |
0 |
| SKIP_INACCESSIBLE |
NUMBER |
1 |
| SKIP_OFFLINE |
NUMBER |
2 |
| SKIP_READONLY |
NUMBER |
3 |
|
| Dependencies |
| DBMS_OUTPUT |
TS$ |
| DBMS_PLUGTS |
V$DB_TRANSPORTABLE_PLATFORM |
| DBMS_SYS_ERROR |
V$TRANSPORTABLE_PLATFORM |
| DUAL |
X$KCVFH |
| GV$DATABASE |
X$KTUSUS |
| GV$DATAFILE |
X$KTUXE |
|
| Exceptions |
None
|
| Security Model |
Execute is granted to the DBA role |
| |
| CHECK_DB |
Overload 1 |
dbms_tdb.check_db(
target_platform_name IN VARCHAR2,
skip_option IN
NUMBER)
RETURN BOOLEAN; |
SELECT platform_name
FROM gv$transportable_platform
ORDER BY 1;
set serveroutput on
DECLARE
x BOOLEAN;
BEGIN
x := dbms_tdb.check_db('Microsoft Windows IA (32-bit)',
0);
IF x THEN
dbms_output.put_line('TRUE');
ELSE
dbms_output.put_line('FALSE');
END IF;
END;
/ |
Overload 2 |
dbms_tdb.check_db(target_platform_name
IN VARCHAR2) RETURN BOOLEAN; |
SELECT platform_name
FROM gv$transportable_platform
ORDER BY 1;
set serveroutput on
DECLARE
x BOOLEAN;
BEGIN
x := dbms_tdb.check_db('Apple Mac OS');
IF x THEN
dbms_output.put_line('TRUE');
ELSE
dbms_output.put_line('FALSE');
END IF;
END;
/
DECLARE
x BOOLEAN;
BEGIN
x := dbms_tdb.check_db('Linux IA (32-bit)');
IF x THEN
dbms_output.put_line('TRUE');
ELSE
dbms_output.put_line('FALSE');
END IF;
END;
/ |
Overload 3 |
dbms_tdb.check_db RETURN BOOLEAN; |
set serveroutput on
DECLARE
x BOOLEAN;
BEGIN
x := dbms_tdb.check_db;
IF x THEN
dbms_output.put_line('TRUE');
ELSE
dbms_output.put_line('FALSE');
END IF;
END;
/
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER DATABASE OPEN READ ONLY;
set serveroutput on
DECLARE
x BOOLEAN;
BEGIN
x := dbms_tdb.check_db;
IF x THEN
dbms_output.put_line('TRUE');
ELSE
dbms_output.put_line('FALSE');
END IF;
END;
/
SHUTDOWN IMMEDIATE;
STARTUP; |
| |
| CHECK_EXTERNAL |
Check if a database has external table,
directory or BFILE. Uses dbms_output.put_line to output
the external objects and their owners |
dbms_tts.check_external RETURN BOOLEAN; |
set serveroutput on
DECLARE
x BOOLEAN;
BEGIN
x := dbms_tdb.check_external;
IF x THEN
dbms_output.put_line('TRUE');
ELSE
dbms_output.put_line('FALSE');
END IF;
END;
/ |
| |
| EXIT_TRANSPORT_SCRIPT |
| Internal: Used in transport script to throw
a SQL error so that the transport script can exit |
dbms_tdb.exit_transport_script(should_exit IN
VARCHAR2); |
| Creates an ORA-09330 |
Free