Extracting Objects

From: Jake <jake_at_kosher.com>
Date: Thu, 14 Dec 2000 19:43:25 +1100
Message-ID: <mL%Z5.2$1J.560@vic.nntp.telstra.net>

Hi,

I want to know if SQL Plus (or another application with command line interface) allows for the following.

I want to extract an object (procedure, package, table, etc) from the database into a local file. SQL Navigator does this by choosing the "Action --> Show SQL" or "Extract DDL" option, but this does not have a command line interface to execute this option.

The results I am after would be the create script for the object.

Can anybody help me with this?

Thanks Received on Thu Dec 14 2000 - 02:43:25 CST