Extracting Objects
From: Jake <jake_at_kosher.com>
Date: Thu, 14 Dec 2000 19:43:25 +1100
Message-ID: <mL%Z5.2$1J.560_at_vic.nntp.telstra.net>
Date: Thu, 14 Dec 2000 19:43:25 +1100
Message-ID: <mL%Z5.2$1J.560_at_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 - 09:43:25 CET