26
Aug
C:\xampp\mysql\bin>mysqldump –user=root –password dp > test.sql
dp = database name
test.sql = Where to locate the file
C:\xampp\mysql\bin>mysqldump –user=root –password dp > test.sql
dp = database name
test.sql = Where to locate the file
1. Start TNS
lsnrctl start
2. set OracleSID
set ORCL
3. Start Service
sc start OracleSERVICE$ORACLE_SID
4. Start Service using oradim
oradim -startup -sid $ORACLE_SID
5. SQLPLUS “/ as sysdba”
6. startup
net use o: \\vboxsvr\foldername
One Of many Product from Oracle. Seal The Document.
Latest Version 11G.
Is it true ?????
SQPLUS “/ as sysdba”
CREATE USER dimas IDENTIFIED BY alamanda;
ALTER USER dimas IDENTIFIED BY alamanda ACCOUNT UNLOCK;
GRANT CREATE ANY DIRECTORY TO dimas;
CREATE OR REPLACE DIRECTORY test_dir AS ‘/u01/app/oracle/oradata/’;
GRANT READ, WRITE ON DIRECTORY test_dir TO dimas;