dbms_tdb Tips FORMATO ENDIAN

conn sys@ora11g as sysdba

Connected to Oracle 11g Enterprise Edition Release 11.1.0.6.0

conn / as sysdba

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 x86 64-bit                    Little

         12 Microsoft Windows x86 64-bit        Little

         17 Solaris Operating System (x86)      Little

         19 HP IA Open VMS                      Little

         20 Solaris Operating System (x86-64)   Little

         21 Apple Mac OS (x86-64)               Little

Now execute the check_db function to get the results:

--Execute the check_db function

set serveroutput on

declare

    v_db_is_ok boolean;

    v_db_is_ok_1 boolean := TRUE;

    begin

   v_db_is_ok := dbms_tdb.check_db(

                  target_platform_name => 'Solaris Operating System (x86-64)',

                  skip_option => dbms_tdb.skip_none);

   if  v_db_is_ok = v_db_is_ok_1 then

     dbms_output.put_line('Database Ready to be transported!' );

   else

     dbms_output.put_line('Database not Ready to be transported!' );

   end if;

 end;

/

Database is not open in read-only mode. Open the database in read-only mode and retry.

Database not ready to be transported!

Next, execute the check_external function in order to list external objects that may exist.

--Execute the check_external function
set serveroutput on
declare
v_ext_exists boolean;
v_ext_exists_1 boolean;
begin
   v_ext_exists := dbms_tdb.check_external;
  if  v_ext_exists = v_ext_exists_1 then
    dbms_output.put_line('Database without external objects!' );           
  else
    dbms_output.put_line('Database have external objects!' );          
  end if;
  
end;
/