Print Thread
No exporting objects when using Commad line
#64861 10/20/23 08:22 AM
Joined: Dec 2019
Posts: 44
T
TomOzi Offline OP
Member
OP Offline
Member
T
Joined: Dec 2019
Posts: 44
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.

Attached Files
Annotation 2023-10-20 111756.png (7.63 KB, 26 downloads)
Re: No exporting objects when using Commad line
TomOzi #64863 10/20/23 08:36 AM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
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


Marco Kalter
Allround Automations
Re: No exporting objects when using Commad line
Marco Kalter #64866 10/20/23 09:11 AM
Joined: Dec 2019
Posts: 44
T
TomOzi Offline OP
Member
OP Offline
Member
T
Joined: Dec 2019
Posts: 44
Thanks. initially I used command file.
The error was resolved by adding a key "sessionmode=multi"

Re: No exporting objects when using Commad line
TomOzi #64867 10/20/23 09:14 AM
Joined: Dec 2019
Posts: 44
T
TomOzi Offline OP
Member
OP Offline
Member
T
Joined: Dec 2019
Posts: 44
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?

Re: No exporting objects when using Commad line
TomOzi #64874 10/23/23 08:10 AM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
You can go to Preferences > Files > Format and set the encoding option to "Always UTF8".


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.031s Queries: 16 (0.009s) Memory: 2.5145 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-05-11 13:17:37 UTC
Valid HTML 5 and Valid CSS