![]() ![]() SQL> ALTER TABLESPACE mytestts READ ONLY ![]() SQL>SELECT * FROM transport_set_violations Īssuming no violations are produced we are ready to proceed by switching the tablespace to read only mode. The TRANSPORT_SET_VIOLATIONS view is used to check for any violations. SQL>EXEC DBMS_TTS.TRANSPORT_SET_CHECK(ts_list => 'mytestts', incl_constraints => TRUE) ![]() The TS_LIST parameter accepts a comma separated list of tablespace names and the INCL_CONSTRAINTS parameter indicates if constraints should be included in the check. This can be checked using the DBMS_TTS.TRANSPORT_SET_CHECK procedure. SQL> INSERT /*+ APPEND */ INTO test_table (id, description)įor a tablespace to be transportable it must be totally self contained. SQL> GRANT CREATE SESSION, CREATE TABLE TO test_user ĬONSTRAINT test_table_pk PRIMARY KEY (id) SQL> CREATE USER test_user IDENTIFIED BY test_user DEFAULT TABLESPACE mytestts TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON mytestts SQL> ALTER TABLESPACE mytestts ADD DATAFILEe '/u01/data/mytestts02.dbf' SIZE 1M AUTOEXTEND ON NEXT 1M SQL> CREATE TABLESPACE mytestts DATAFILE '/u01/data/mytestts01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1M For this example I'm going to create a new tablespace, user and table to work with in the source database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |