首页 » ORACLE » ORACLE DBMS_TDS

ORACLE DBMS_TDS

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
打赏

对不起,这篇文章暂时关闭评论。