Hinzinfotech

Export and Import using all parameters: 1.SOURCE_EDITION Parameter SQL> show userUSER is “SYS”SQL> GRANT CREATE ANY EDITION, DROP ANY EDITION to remo;Grant succeeded.SQL> alter user remo enable editions;User altered.SQL> grant create any view to remo;Grant succeeded.SQL> select USERNAME,EDITIONS_ENABLED from dba_users where USERNAME=’REMO’; USERNAME E-REMOYSQL> col USERNAME for a10SQL> / USERNAME E REMO YSQL> conn remo/remoConnected.SQL> […]

High Water Mark management in Oracle Database: Description: ⦁ Each table is made up of extents and each extent is made up of oracle blocks – a common block size is 8k. So you have a table with 10 extents (80K). ⦁ When any table creates the high water mark will be in the ‘starting’ position. The high water mark keep moving forward […]

Table Partition: SQL>select * from user_part_tables; SQL>select * from user_tab_partitions; SQL> select table_name,table_owner,partition_name,subpartition_count from dba_tab_partitions where table_name='<table_name>’; Oracle you can partition a table by CREATING PARTITION TABLES 1)Range Partitioning:  This type of partitioning is useful when dealing with data that has logical ranges into which it can be distributed;for example, value of year. Performance is […]