Oracle Imp show=y & Indexfile: How to generate sql scripts from Oracle dump file?

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World

imp SHOW=Y
Import (imp) is the oracle utility to read export dump files and insert them into database. Export dump files can only be read by imp utility. Using SHOW=Y option, the content of the dump file can be generated into readable ASCII format. If we use this option with Y as the value the content of the dump will not be inserted into the database whereas it will spool the sql statements to the log file. SHOW option can be used only with FULL=Y, FROMUSER, TOUSER and TABLES mode.


Scenario: Generate table creation script for a schema from the dump
Imp file=exp_schema.dmp log=imp_schema_script.log full=y show=y rows=n

imp indexfile=index.sql
Indexfile: This is another option with import (imp) utility to generate index DDL script from the export dump.  INDEXFILE option will spool the CREATE INDEX statements (including storage parameters) to the filename which specify in the indexfile. This will not generate primary key indexes.

_____________________________________________________________________________________________________________________

A visitor from Chennai viewed '12c RAC Data Guard DGMGRL: show configuration fail' 2 hrs 51 mins ago
A visitor from Putrajaya viewed 'How to Find out / Check SGA and PGA size of Oracle' 2 hrs 54 mins ago
A visitor from Chongqing viewed 'Purpose of ADR_BASE_Listener & DIAG_ADR_ENABLED_li' 3 hrs 6 mins ago
A visitor from Hitzendorf viewed 'DGMGRL Error: ORA-16820: fast-start failover obser' 5 hrs 35 mins ago
A visitor from Hitzendorf viewed 'DGMGRL Error: ORA-16647: could not start more than' 5 hrs 48 mins ago

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-25 All Rights Reserved | Site Map | Contact | Disclaimer