Ask a Question

Run SQL script on the server from within SQL developer on the client?

in Education by
I am trying to create a pluggable database and am executing commands through sqldeveloper. For enabling the 32k varchar support I need to run the script "@?/rdbms/admin/utl32k.sql;"..This script is present in the oracle database server. But my sqldeveloper is installed on a different machine..Is there any way to tell sqldeveloper that the path is relative to the server path and should be executed within the server ? JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

1 Answer

0 votes
by
When running scripts in SQL Developer, there's no context or reference of any files on the database server itself. So to run from a client connected to your database, a file on the db server...you would have to have a mapped drive or something similar. So on your Windows/Mac, map a drive to the oracle db server as say F:, and then in your worksheet, you'd execute @f:/.../script.sql What you REALLY should be doing though, is SSHing into the database server, and from a terminal, run SQL*Plus as SYS to execute that script.

Related questions

0 votes
Q: Working With SQL Server Developer Edition [closed]
    Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 11, 2022 in Education by JackTerrance
0 votes
Q: Working With SQL Server Developer Edition [closed]
    Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 11, 2022 in Education by JackTerrance
0 votes
Q: Working With SQL Server Developer Edition [closed]
    Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 10, 2022 in Education by JackTerrance
0 votes
Q: State true or false: SAP systems are divided into different clients depending on business requirement, the data can be accessed within the client only.
    State true or false: SAP systems are divided into different clients depending on business requirement, the data can be accessed within the client only. A. True B. False...
asked Feb 20, 2023 in Technology by JackTerrance
0 votes
Q: Write a program which sends the name of a text file from the client to server and display the message on the client machine whether file present or not.
    Write a program which sends the name of a text file from the client to server and display the message on the ... file present or not. Select the correct answer from above options...
asked Dec 1, 2021 in Education by JackTerrance
0 votes
Q: Which of these class is used for operating on request from the client to the server?
    Which of these class is used for operating on request from the client to the server? (a) http (b) ... programming questions and answers pdf, java interview questions for beginners...
asked Oct 25, 2021 in Education by JackTerrance
0 votes
Q: Client-side JavaScript code is embedded within HTML documents in __________
    Client-side JavaScript code is embedded within HTML documents in __________ (a) A URL that uses the special ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Oct 22, 2021 in Education by JackTerrance
0 votes
Q: How to fire EC2 instances and upload/run a startup script on each of them?
    I want to automate the launch of a set of Linux EC2 instances. Basically, I want to write a script/program that ... in Amazon AWS/EC2? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
Q: Run R script from command line
    I have file called q.r and it has chmod of 755, how can I run it using a command-line? sayHello...
asked Jan 24, 2022 in Education by JackTerrance
0 votes
Q: Code is not executing within Javascript module typed script source [ES6]
    Trying to use ES6 but I'm stuck on something. To make it simple there is two problems : JS ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 17, 2022 in Education by JackTerrance
0 votes
Q: Use XSL to generate dynamic XSL that is executed within the same script?
    I want to dynamically create variables with dynamic names for later use in my transform, but to do this ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 10, 2022 in Education by JackTerrance
0 votes
Q: Use XSL to generate dynamic XSL that is executed within the same script?
    I want to dynamically create variables with dynamic names for later use in my transform, but to do this ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 8, 2022 in Education by JackTerrance
0 votes
Q: Detecting interactive shell within ksh ENV script
    What's the preferred way to determine if a given ksh invocation is running an interactive shell? I have ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 26, 2022 in Education by JackTerrance
0 votes
Q: How do I grab an INI value within a shell script?
    I have a parameters.ini file, such as: [parameters.ini] database_user = user database_version = 20110611142248 I want to ... I do this? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...