No exporting objects when using Commad line

TomOzi

Member²
HI
I'm try to export objects current schema using command line command;

Code:
plsqldev.exe noplugins UserID=user/pass@db Export Objects= IncludePrivs IncludeStorage IncludeOwner FilePerObject2 Filename="C:\db\db.sql"

db.sql file:

Code:
Export Objects= IncludePrivs IncludeStorage IncludeOwner FilePerObject2 Filename="C:\db\export.sql";

the applicaiton is runing but i got message:

Code:
SQL>
Exporting Objects=
Could not execute, session was busy
Exporting Done.

but if i run this string into command window it works fine.

Annotation 2023-10-20 111756.png
 
These commands can only be executed in the Command Window. They cannot be directly placed on the plsqldev.exe command-line. You can however create a Command File that performs the export, and execute that from the command-line:

plsqldev.exe userid=username/password@database commandfile=c:\export\export.sql
 
One more question.
Some file creating with encoding utf-8, some: win-1251, some: Machintosh
is there a way all saved files do encoding utf-8?
 
Back
Top