How to get Data Definition Language (DDL) statements ? Parameter: SQLFILE

Posted on November 16, 2009. Filed under: Oracle | Tags: |

How to get Data Definition Language (DDL) statements ? Parameter: SQLFILE

With the Import Data Pump parameter SQLFILE you can specify the name of a file into which all of the SQL DDL is written that Import would have executed, based on other parameters. The SQL is not actually executed, and the target system remains unchanged. The file is written to the directory object specified in the DIRECTORY parameter, unless another directory_object is explicitly specified here. Any existing file that has a name matching the one specified with this parameter is overwritten.
Syntax: SQLFILE=[directory_object:]file_name
Example:

-- create a SQL file with DDL statements:

% impdp scott/tiger DIRECTORY=my_dir DUMPFILE=expdp_s.dmp \
NOLOGFILE=y SQLFILE=impdp_s.sql FULL=y


Read Full Post | Make a Comment ( None so far )

Recently on Parthokonar's Blog…

Check running process of expdp impdp in oracle

Posted on November 16, 2009. Filed under: Oracle Scripts | Tags: , |

The PUBLIC role/User in Oracle.

Posted on November 16, 2009. Filed under: Oracle | Tags: , , |

Dropping user in oralce by killing active sessions

Posted on October 29, 2009. Filed under: Oracle | Tags: , |

Cloning An Oracle Database in Windows

Posted on October 28, 2009. Filed under: Oracle | Tags: , , |

Creating a flat file from a table

Posted on September 18, 2009. Filed under: Oracle | Tags: , |

parameters affect database tuning

Posted on September 9, 2009. Filed under: Oracle | Tags: |

Latches and Enqueues

Posted on September 1, 2009. Filed under: Oracle | Tags: , , |

Blocking Transaction

Posted on August 31, 2009. Filed under: Oracle | Tags: |

How to remove a parameter from spfile

Posted on August 26, 2009. Filed under: Oracle | Tags: , |

  • Calender

    November 2014
    M T W T F S S
    « Nov    
     12
    3456789
    10111213141516
    17181920212223
    24252627282930

Liked it here?
Why not try sites on the blogroll...

Follow

Get every new post delivered to your Inbox.