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
sys@ORCL> select * from V$TRANSPORTABLE_PLATFORM;
PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT
----------- ----------------------------------------------------------------------------------------------------- --------------
1 Solaris[tm] OE (32-bit) Big
2 Solaris[tm] OE (64-bit) Big
7 Microsoft Windows IA (32-bit) Little
10 Linux IA (32-bit) Little
6 AIX-Based Systems (64-bit) Big
3 HP-UX (64-bit) Big
5 HP Tru64 UNIX Little
4 HP-UX IA (64-bit) Big
11 Linux IA (64-bit) Little
15 HP Open VMS Little
8 Microsoft Windows IA (64-bit) Little
9 IBM zSeries Based Linux Big
13 Linux 64-bit for AMD Little
16 Apple Mac OS Big
12 Microsoft Windows 64-bit for AMD Little
17 Solaris Operating System (x86) Little
18 IBM Power Based Linux Big
17 rows selected.
sys@ORCL> select * from V$DB_TRANSPORTABLE_PLATFORM;
PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT
----------- ----------------------------------------------------------------------------------------------------- --------------
7 Microsoft Windows IA (32-bit) Little
10 Linux IA (32-bit) Little
5 HP Tru64 UNIX Little
11 Linux IA (64-bit) Little
15 HP Open VMS Little
8 Microsoft Windows IA (64-bit) Little
13 Linux 64-bit for AMD Little
12 Microsoft Windows 64-bit for AMD Little
17 Solaris Operating System (x86) Little
9 rows selected.
sys@ORCL> DECLARE
2 x BOOLEAN;
3 BEGIN
4 x := dbms_tdb.check_db('Microsoft Windows IA (32-bit)', 0);
5 IF x THEN
6 dbms_output.put_line('TRUE');
7 ELSE
8 dbms_output.put_line('FALSE');
9 END IF;
10 END;
11 /
TRUE
PL/SQL procedure successfully completed.
sys@ORCL> DECLARE
2 x BOOLEAN;
3 BEGIN
4 x := dbms_tdb.check_db('Microsoft Windows IA (64-bit)', 0);
5 IF x THEN
6 dbms_output.put_line('TRUE');
7 ELSE
8 dbms_output.put_line('FALSE');
9 END IF;
10 END;
11 /
TRUE
PL/SQL procedure successfully completed.
sys@ORCL> DECLARE
2 x BOOLEAN;
3 BEGIN
4 x := dbms_tdb.check_db('HP-UX IA (64-bit)', 0);
5 IF x THEN
6 dbms_output.put_line('TRUE');
7 ELSE
8 dbms_output.put_line('FALSE');
9 END IF;
10 END;
11 /
The specified target platform name 'HP-UX IA (64-bit)' is invalid or the target platform is not transportable.
FALSE
PL/SQL procedure successfully completed.
sys@ORCL> DECLARE
2 x BOOLEAN;
3 BEGIN
4 x := dbms_tdb.check_db('HP-UX (64-bit)', 0);
5 IF x THEN
6 dbms_output.put_line('TRUE');
7 ELSE
8 dbms_output.put_line('FALSE');
9 END IF;
10 END;
11 /
The specified target platform name 'HP-UX (64-bit)' is invalid or the target platform is not transportable.
FALSE
PL/SQL procedure successfully completed.
sys@ORCL> DECLARE
2 x BOOLEAN;
3 BEGIN
4 x := dbms_tdb.check_db('HP Tru64 UNIX', 0);
5 IF x THEN
6 dbms_output.put_line('TRUE');
7 ELSE
8 dbms_output.put_line('FALSE');
9 END IF;
10 END;
11 /
TRUE
PL/SQL procedure successfully completed.
sys@ORCL> DECLARE
2 x BOOLEAN;
3 BEGIN
4 x := dbms_tdb.check_external;
5 IF x THEN
6 dbms_output.put_line('TRUE');
7 ELSE
8 dbms_output.put_line('FALSE');
9 END IF;
10 END;
11 /
The following external tables exist in the database:
SH.SALES_TRANSACTIONS_EXT, SYSTEM.ALERT_LOG
The following directories exist in the database:
SYS.EXPDIR, SYS.BDUMP, SYS.DATA_PUMP_DIR, SYS.SUBDIR, SYS.XMLDIR, SYS.MEDIA_DIR, SYS.LOG_FILE_DIR, SYS.DATA_FILE_DIR, SYS.WORK_DIR, SYS.ADMIN_DIR
The following BFILEs exist in the database:
PM.PRINT_MEDIA
TRUE
PL/SQL procedure successfully completed.
sys@ORCL> !uname -a
Linux orazhang 2.6.18-53.el5xen #1 SMP Wed Oct 10 17:06:12 EDT 2007 i686 i686 i386 GNU/Linux