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)

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips