Re: exp/imp DDL

A much simpler and cleaner way (instead of import/export) is to use my SQL PlusPlus (freeware) to get DDL in any format in a clearly formatted "clean" output.

For example to get DDL for all objects releated to all tables in SCOTT schmea, all you need to do is execute the following in SQL Plus:

SQL> EXEC S.GETALL('%','SCOTT') regards,
M. Armaghan Saqib

• SQL PlusPlus: Add power to SQL Plus.
• SQL Link for XL: Integrate Oracle with XL.
• Oracle CBT with sample GL (Triggers and Forms Source Code included. Download free: http://www.geocities.com/armaghan/

  ---

In article <86c8d0$dgs$1_at_bgtnsc01.worldnet.att.net>,   "Buck Turgidson" <jcmanNOSPAM_at_worldnet.att.net> wrote:
> When using export/import to capture DDL, it adds quotation marks to
it. SQL
> Plus complains about this. Is there a way to get around this?
>
> Sample Output:
>
> "CREATE TABLE "T" ("X" NUMBER(*,0)) PCTFREE 10 PCTUSED 40 INITRANS 1
> MAXTRA"
> "NS 255 LOGGING STORAGE(INITIAL 524288) TABLESPACE "UTILS""
> "CREATE INDEX "DUMMY" ON "T" ("X" ) PCTFREE 10 INITRANS 2 MAXTRANS
255
> STOR"
> "AGE(INITIAL 524288) TABLESPACE "UTILS" LOGGING"
>
> SQL> "CREATE TABLE "T" ("X" NUMBER(*,0)) PCTFREE 10 PCTUSED 40
INITRANS 1
> MAXTRA"
> unknown command beginning ""CREATE TA..." - rest of line ignored.
> SQL> "NS 255 LOGGING STORAGE(INITIAL 2048) TABLESPACE "USER""
> unknown command beginning ""NS 255 LO..." - rest of line ignored.
> SQL> "CREATE INDEX "DUMMY" ON "T" ("X" ) PCTFREE 10 INITRANS 2
MAXTRANS 255
> STOR"
> unknown command beginning ""CREATE IN..." - rest of line ignored.
> SQL> "AGE(INITIAL 524288) TABLESPACE "USER" LOGGING"
> unknown command beginning ""AGE(INITI..." - rest of line ignored.
> For a list of known commands enter HELP
> and to leave enter EXIT.
>
>

--

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 25 2000 - 05:04:44 CST