Contents
How do I import a database into SQL Plus?
sqlplus / AS SYSDBA SQL> ALTER SESSION SET CONTAINER=XEPDB1; SQL> CREATE DIRECTORY DUMP_DIR AS ‘C:\temp\dump’;; SQL> GRANT READ, WRITE ON DIRECTORY DUMP_DIR TO SYSTEM; Import data to your 18c XE database from the dump folder. Remapping the directory is necessary when you use different directory file naming conventions.
How do I run an Oracle script in putty?
To run the SQL script, follow these steps:
- Open the command prompt by pressing the key Window+R and then type CMD in the Run window and press enter.
- In the Windows command prompt, change the directory where your SQL script exists, for example, CD F:\mysqlscripts and press enter.
How do I run a SQL script in putty?
STEP1: enter your Hostname or I.P address and use port 22 @ putty. If you are entering your hostname, leave out the http://www and simply enter yourdomain.com. STEP3: Then enter your cPanel password and click enter. and click enter.
How do I connect to MySQL using putty?
Download and launch PuTTy. In the category tree on the left, click Connection: SSH :Tunnels near the bottom. Enter 3306 in the source port. Enter your MySQL database address and port in the destination field (e.g., mysql .example.com:3306). Use all other defaults (local, auto) and click Add. Click to read more on it.
How to enter a database through putty-database?
It will prompt for the Oracle SID (which you now from the person you tells you the information to connect to it. This script will then automatically set the corrent environment variables for you. Thanks for contributing an answer to Database Administrators Stack Exchange! Please be sure to answer the question.
How to start SQL Plus and connect to the database?
The section describes how to start SQL*Plus and connect to the database from both the command line and the Windows Start menu. For a new installation, you connect to the database using either the SYS or SYSTEM database accounts.
How to use putty to import a sql file?
U can use the putty utility PLINK.EXE Preferred configure the session with a key, to not need to put the password in all the connections, so simple use: is in your /home/user. More information about PLINK: http://the.earth.li/~sgtatham/putty/0.58/htmldoc/Chapter7.html