{"id":167,"date":"2022-02-01T09:40:20","date_gmt":"2022-02-01T09:40:20","guid":{"rendered":"https:\/\/vkrastev1blog.com\/?p=167"},"modified":"2026-10-19T12:28:46","modified_gmt":"2026-10-19T12:28:46","slug":"sql-developer-execute-big-sql-files-scripts-in-sql-developer","status":"publish","type":"post","link":"https:\/\/vkrastev1blog.com\/2022\/02\/01\/sql-developer-execute-big-sql-files-scripts-in-sql-developer\/","title":{"rendered":"SQL Developer &#8211; ejecuta archivos\/scripts .sql grandes en SQL Developer"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">SQL Developer: ejecute archivos\/scripts .sql grandes en SQL Developer<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Abra SQL Developer, luego presione Alt &#8211; F10 y le mostrar\u00e1 un cuadro de di\u00e1logo Elegir conexi\u00f3n. Elija una conexi\u00f3n y se abrir\u00e1 un editor SQL para esa conexi\u00f3n. Escribe en \u00e9l solo <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">@C:\\Usuarios\\KrastevV\\Project\\sql.sql<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Firme @ seguido de la Ruta al Script y ejec\u00fatelo con el bot\u00f3n de reproducci\u00f3n.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2022\/02\/bild.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"751\" height=\"451\" data-attachment-id=\"171\" data-permalink=\"https:\/\/vkrastev1blog.com\/2022\/02\/01\/sql-developer-execute-big-sql-files-scripts-in-sql-developer\/bild\/\" data-orig-file=\"https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2022\/02\/bild.png?fit=751%2C451&amp;ssl=1\" data-orig-size=\"751,451\" data-comments-opened=\"1\" data-image-title=\"bild\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2022\/02\/bild.png?fit=751%2C451&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2022\/02\/bild.png?resize=751%2C451&#038;ssl=1\" alt=\"\" class=\"wp-image-171\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Developer: ejecute archivos\/scripts .sql grandes en SQL Developer Abra SQL Developer, luego presione Alt &#8211; F10 y le mostrar\u00e1 un cuadro de di\u00e1logo Elegir conexi\u00f3n. Elija una conexi\u00f3n y se abrir\u00e1 un editor SQL para esa conexi\u00f3n. Escribe en \u00e9l solo @C:\\Usuarios\\KrastevV\\Project\\sql.sql Firme @ seguido de la Ruta al Script y ejec\u00fatelo con el [&hellip;]<\/p>\n","protected":false},"author":65283547,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[559],"tags":[729296054],"class_list":["post-167","post","type-post","status-publish","format-standard","hentry","category-others","tag-slq-developer"],"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4CoHV-2H","jetpack-related-posts":[{"id":237,"url":"https:\/\/vkrastev1blog.com\/2023\/09\/12\/mssql-configure-server-for-sql-authentication-mssql-login-with-username-and-password\/","url_meta":{"origin":167,"position":0},"title":"MSSQL configura el servidor para la autenticaci\u00f3n SQL. Inicio de sesi\u00f3n MSSQL con nombre de usuario y contrase\u00f1a","author":"vkrastev2014","date":"12.09.2023","format":false,"excerpt":"In SQL Server Management Studio (SSMS) Object Explorer, right-click the server, and then select Properties. On the Security page, under Server authentication, select 'SQL and Windows authentication mode', and then select OK. You have to restart the server. You can try to access the Database from command line with: sqlcmd\u2026","rel":"","context":"In &quot;Otros&quot;","block_context":{"text":"Otros","link":"https:\/\/vkrastev1blog.com\/category\/others\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":174,"url":"https:\/\/vkrastev1blog.com\/2022\/02\/08\/create-dump-from-oracle-schema-in-console-in-linux\/","url_meta":{"origin":167,"position":1},"title":"Crear volcado desde el esquema de Oracle en la consola en Linux","author":"vkrastev2014","date":"08.02.2022","format":false,"excerpt":"It is not easy to find the correct way to execute expdp command in console. There are some steps before you execute expdp command. First you have to create a directory on the computer where Oracle DB is, where you will put the dump files than you have to grant\u2026","rel":"","context":"In &quot;Otros&quot;","block_context":{"text":"Otros","link":"https:\/\/vkrastev1blog.com\/category\/others\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":55,"url":"https:\/\/vkrastev1blog.com\/2014\/05\/11\/important-shell-script-commands-which-are-oft-used\/","url_meta":{"origin":167,"position":2},"title":"Comandos importantes del script de Shell que se utilizan a menudo","author":"vkrastev2014","date":"11.05.2014","format":false,"excerpt":"Here is a list of some important shell commands: ---- Using Screen command screen -ls -- for a list of avaliable active screens screen -x .... - the Name from -ls output to join to this active screen Go out of the Screen with 'ctrl a+d' without stopping it ----\u2026","rel":"","context":"In &quot;Otros&quot;","block_context":{"text":"Otros","link":"https:\/\/vkrastev1blog.com\/category\/others\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2308,"url":"https:\/\/vkrastev1blog.com\/2026\/05\/29\/questions-and-informations-prepairing-for-java-developer-job-interview\/","url_meta":{"origin":167,"position":3},"title":"Preguntas e informaci\u00f3n sobre la preparaci\u00f3n para la entrevista de trabajo de desarrollador de Java","author":"vkrastev2014","date":"29.05.2026","format":false,"excerpt":"\u0412\u044a\u043f\u0440\u043e\u0441\u0438 \u0438 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044f \u0437\u0430 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043a\u0430 \u0437\u0430 \u0438\u043d\u0442\u0435\u0440\u0432\u044e \u0437\u0430 \u0440\u0430\u0431\u043e\u0442\u0430 \u043a\u0430\u0442\u043e Java Developer \u041a\u0430\u043a\u0432\u043e \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0432\u0430\u0442 SOLID \u043f\u0440\u0438\u043d\u0446\u0438\u043f\u0438\u0442\u0435? \u041a\u0430\u043a\u0432\u043e \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0432\u0430 Single Responsibility Principle (SRP) \u0415\u0434\u0438\u043d \u043a\u043b\u0430\u0441 \u0442\u0440\u044f\u0431\u0432\u0430 \u0434\u0430 \u0438\u043c\u0430 \u0441\u0430\u043c\u043e \u0435\u0434\u043d\u0430 \u043e\u0442\u0433\u043e\u0432\u043e\u0440\u043d\u043e\u0441\u0442 \u0438 \u0441\u0430\u043c\u043e \u0435\u0434\u043d\u0430 \u043f\u0440\u0438\u0447\u0438\u043d\u0430 \u0434\u0430 \u0431\u044a\u0434\u0435 \u043f\u0440\u043e\u043c\u0435\u043d\u044f\u043d.\u041f\u043e\u043b\u0437\u0438\u0442\u0435 \u0432\u043a\u043b\u044e\u0447\u0432\u0430\u0442 \u043f\u043e-\u043b\u0435\u0441\u043d\u043e \u0442\u0435\u0441\u0442\u0432\u0430\u043d\u0435, \u043f\u043e-\u043d\u0438\u0441\u043a\u043e n\u0438\u0432\u043e \u043d\u0430 coupling \u0438 \u043f\u043e-\u0434\u043e\u0431\u0440\u0430 \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u0430\u0446\u0438\u044f.\u041f\u0440\u0438\u043c\u0435\u0440: public class Book\u2026","rel":"","context":"In &quot;Java&quot;","block_context":{"text":"Java","link":"https:\/\/vkrastev1blog.com\/category\/java\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2026\/05\/image-9.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2026\/05\/image-9.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2026\/05\/image-9.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/vkrastev1blog.com\/wp-content\/uploads\/2026\/05\/image-9.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":232,"url":"https:\/\/vkrastev1blog.com\/2022\/10\/31\/install-solr-8-under-windows-as-service\/","url_meta":{"origin":167,"position":4},"title":"Instale Solr 8 en Windows como servicio","author":"vkrastev2014","date":"31.10.2022","format":false,"excerpt":"Here is short explained how to install Solr 8 as Windows service Download nssm from https:\/\/nssm.cc\/release\/nssm-2.24.zip and extract it to C:\\Program Files\\nssm Donwload Solr 8 from https:\/\/dlcdn.apache.org\/lucene\/solr\/8.11.2\/solr-8.11.2.zip and extract it to C:\\web\\solr Java Version 8 or later have to be istalled and JAVA_HOME environment variable set Create Windows Service solr8.\u2026","rel":"","context":"In &quot;Otros&quot;","block_context":{"text":"Otros","link":"https:\/\/vkrastev1blog.com\/category\/others\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":194,"url":"https:\/\/vkrastev1blog.com\/2022\/03\/30\/java-configure-log4j2-in-your-project\/","url_meta":{"origin":167,"position":5},"title":"Java configura Log4j2 en tu proyecto","author":"vkrastev2014","date":"30.03.2022","format":false,"excerpt":"Log4j2 and SLF4j Binding DependenciesTo make Log4j2 work with SLF4J, we need to include the following 3 dependencies. log4j-slf4j-impl.jar \u2013 Log4j 2 SLF4J binding. It allows applications coded to the SLF4J API to use Log4j2 as the implementation.log4j-api.jar \u2013 provides the adapter components required for implementers to create a logging\u2026","rel":"","context":"In &quot;Java&quot;","block_context":{"text":"Java","link":"https:\/\/vkrastev1blog.com\/category\/java\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts\/167","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/users\/65283547"}],"replies":[{"embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/comments?post=167"}],"version-history":[{"count":6,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts\/167\/revisions"}],"predecessor-version":[{"id":2827,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/posts\/167\/revisions\/2827"}],"wp:attachment":[{"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/media?parent=167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/categories?post=167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vkrastev1blog.com\/wp-json\/wp\/v2\/tags?post=167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}