Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
CREATE TABLE my_table ( id NUMBER, description VARCHAR2(50) ); -- This table will have 131 million records. --Next we create a new partitioned table with a single partition to act as our destination table. CREATE TABLE my_table_2 ( id NUMBER, description VARCHAR2(50) ) PARTITION BY RANGE (id) (PARTITION my_table_part VALUES LESS THAN (MAXVALUE)); ---Next we switch the original table segment with the partition segment. ALTER TABLE my_table_2 EXCHANGE PARTITION my_table_part WITH TABLE my_table WITHOUT VALIDATION; --We can now drop the original table and rename the partitioned table. DROP TABLE my_table; RENAME my_table_2 TO my_table; --Finally we can split the partitioned table into multiple partitions as required and gather new statistics. ALTER TABLE my_table SPLIT PARTITION my_table_part AT (3) INTO (PARTITION my_table_part_1, PARTITION my_table_part_2); EXEC DBMS_STATS.gather_table_stats(USER, 'MY_TABLE', cascade => TRUE);