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

    October 2014
    M T W T F S S
    « Nov    
     12345
    6789101112
    13141516171819
    20212223242526
    2728293031  

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

Follow

Get every new post delivered to your Inbox.