New answers tagged

0

From MySQL documentation, it seems it is not possible, since it is operating systems temporary directory and not it is not configured in MySQL. When using LOCAL with LOAD DATA, a copy of the file is created in the server's temporary directory. This is not the directory determined by the value of tmpdir or slave_load_tmpdir, but rather the operating ...


2

That is the typical error message you get on Windows without properly setting up the environment. While the steps in the manual may work flawlessly on Linux/UNIX, on Windows you need extra steps. On Windows, you need to create a service with oradim, start it (if it was not started), and after that you can use sqlplus / as sysdba. The bare minimum is: set ...


1

In order to do a clone, you need to connect to the target database which is the database that you are cloning from. In this case you are doing a restore. So there is no auxiliary database. Just do a startup nomount, provided that you have a pfile with the proper settings. Then restore a specific control file as in "restore control file from ...


1

Your connection string is wrong. With easy connect you need to provide a hostname and servicename/SID. In your case you would provide sqlplus user/"SomePass"@HOSTNAME:$PORT/servicename If you want to configure your connection in the tnsnames.ora, you can connect to it using sqlplus user/"SomePass"@TNSALIAS I actually don't understand the part of your ...



Top 50 recent answers are included