Re: Oracle 10g - restore generated ddl -

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 10 Jul 2007 20:42:45 +0200
Message-ID: <f70jv3$acc$1@news5.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Mariano wrote:
> I have generate a ddl in Oracle 10g, script file is something like
> that:

[snip ddl]
>
> How I can avoid to insert the instruction one by one, there is a way
> to execute the script???

DDL != inserts

What is your problem?
you cannot "queue" DDL statements - these are executed one after the other (as DDL involves implicit commits)

You can save these statements in a file, and tell SQL*Plus to read and process the file:
@my_file.sql (if your file is called "my_file.sql"), or @my_file (SQL*Plus tries files with a .sql extension by default)

That will save *you* the keystrokes, but the statements are still executed one after the other.

-- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGk9MlLw8L4IAs830RAsZZAKCBiB4Veyt7Bs+cA5uwaZVafye43gCfXqQ2 Qj1yA7Q96KCfYqnF6VEsRAo=
=QdgM
-----END PGP SIGNATURE----- Received on Tue Jul 10 2007 - 13:42:45 CDT