30Jul/100
Create User and Grant
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;
29Jul/100
Hot Backup
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;
29Jul/100
Simple Primes
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace Prima
{
class Program
{
29Jul/100
Export To TXT File
using System;
using System.Configuration;
using System.Data;
using System.Data.OracleClient;
using System.IO;
//using Oracle.DataAccess.Client;
//using Oracle.DataAccess.Types;
namespace AutoReport
{
class Program
{
