web site statistics

punyadimas.com

.:: semua punyadimas ! ::.

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;

select username, default_tablespace from dba_users
select username, default_tablespace from dba_users where username = ‘SCOTT’
alter tablespace USERS begin backup;
alter tablespace USERS End backup;