1) exec dbms_tts is the Package usedForChecking wheather a set of the
      tablespace is self Contained or Not .
      TRANSPORT_SET_VIOLATIONS View is the View which stores all the
      Violations, whichare there Because of this.

2) System and temp table spaces cannot be included in the Transportable set
     set of the tablespaces.

3) RollBack segments are not allowed in the Transportable set .

 4) EXP TRANSPORT_TABLESPACE=y TABLESPACES=sales_1,sales_2
     TRIGGERS=y/n CONSTRAINTS=y/n GRANTS=y/n FILE=expdat.dmp

Getting Random Population/Sample Using the DBMS_UTILITY Of the Oracle8i/9i

Getting Random Words Oracle Table Using the dbms_Utility Package.
Get_Hash_Value Procedure of the DBMS_UTILITY Package can be Used as

Following For Generating the Random Values From a Sample For testing Purpose.

Suppose u want to Get RandomWords From Some Table for some application than Following is Useful in Generating It.

      Select * from tablenamet
      order by DBMS_UTILITY.GET_HASH_VALUE(TO_CHAR(dbms_utility.get_time),2 ,1048576)

Return to : Oracle Database, SQL, Application, Programming Tips