# Impdp full dump

**URL:** <https://www.batmunkh.net/t/impdp-full-dump/1141>\
**Category:** Oracle Database\
**Created:** [July 1, 2019, 2:02pm UTC](https://www.batmunkh.net/t/impdp-full-dump/1141 "2019-07-01T14:02:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![1118](https://www.batmunkh.net/user_avatar/www.batmunkh.net/1118/32/421_2.png) [@1118](https://www.batmunkh.net/u/1118)\
**Post date:** [July 1, 2019, 2:02pm UTC](https://www.batmunkh.net/t/impdp-full-dump/1141/1 "2019-07-01T14:02:53Z")

</div>

full dump sergeesen chine index ni bga gej haragdaad bga mortloo aimar udaan bgad bhin ene yundaa bdin bolo

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [July 1, 2019, 2:19pm UTC](https://www.batmunkh.net/t/impdp-full-dump/1141/2 "2019-07-01T14:19:11Z")

</div>

rebuild all indexes:

```auto
DECLARE
BEGIN
    FOR index_entry IN (select INDEX_NAME 
                        from user_indexes 
                        where table_name='MY_TABLE' and
                         index_type='NORMAL')
    LOOP
        dbms_output.put_line('ALTER INDEX ' || index_entry.INDEX_NAME || ' REBUILD'); 
        EXECUTE IMMEDIATE 'ALTER INDEX ' || index_entry.INDEX_NAME || ' REBUILD';
    END LOOP;
END;
/

```

Дээрхээс харахад

```auto
select INDEX_NAME 
                        from user_indexes 
                        where table_name='MY_TABLE' and
                         index_type='NORMAL'

```

энэ хэсгийн коммандыг өөрчилөн өөрийн хүссэн индексүүдийг гарган авах боломжтой.

sys хэрэглэгчийн хувьд: dba\_indexes , энгийн хэрэглэгчийн хувьд: user\_indexes -ийг ашиглан хэрэглэгдэж буй индексүүдийг гарган авч болно.

Мөн spool комманд ашиглан rebuild хийх коммандыг гаргаж авч болно. Жишээ нь :

```
SPOOL rebuild_indexes.sql

SELECT 'ALTER INDEX ' || a.index_name || ' REBUILD;'
FROM all_indexes a
WHERE index_name = DECODE(Upper('&1'),'ALL',a.index_name,Upper('&1'))
AND table_owner = Upper('&2')
ORDER BY 1
/

SPOOL OFF

-- Гарсан үр дүнг ажиллуулах
@rebuild_indexes.sql
```
