Toad World® Forums

Generate schema script for multiple schemas

Toad uses ‘/’ character to end of statements however this option is checked off for me. This is happen only if I export multiple schemas at the same time.

T.

Some statements must end with a slash (create procedure, package, function). The option does not apply to these types.

From: drbubo20 [mailto:bounce-urbantamas@toadworld.com]

Sent: Thursday, June 05, 2014 3:36 AM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Generate schema script for multiple schemas

Generate schema script for multiple schemas

Thread created by drbubo20

Toad uses ‘/’ character to end of statements however this option is checked off for me. This is happen only if I export multiple schemas at the same time.

T.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

John,

That’s ok, but these statements in Constraint/Indexes/Tables/Synonym/etc. directory.

If I compare the newly generated schema script with a previous version (which was a single schema export), Winmerge will show differences in all of files because the statement character has changed from “;” to “/”.

I just tried exporting two schemas and the statements to create tables, constraints, indexes, synonyms all end with a semicolon.

If you CTRL+C to copy the action out of automation designer and email it to me, I’ll try again. If you didn’t set it up in the app designer, it will be in the “action recall” section.

John,

It works fine in the GA version. I think it was in one of previous 12.5beta version, but it doesn’t matter now.

Thank,

Tamas