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 Mumbai viewed 'How to Check Which User is Connected to Current Or' 1 min ago
A visitor from Tokyo viewed 'Data Pump IMPDP TABLE_EXISTS_ACTION = APPEND, REPL' 1 hr 35 mins ago
A visitor from Chandigarh viewed 'Oracle SQL Script to Check Index Fragmentation and' 2 hrs 8 mins ago
A visitor from Chandigarh viewed 'Oracle SQL Script to Check Index Fragmentation and' 2 hrs 16 mins ago
A visitor from Kampot viewed 'Unix: Command to check swap space in Solaris & AIX' 3 hrs 51 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