Installation Oracle Linux

created partioned table

exp - imp

Passwörter ändern, accounts öffnen

C:\>cd app\hofstetterm\product\11.1.0\db_1\BIN

C:\app\hofstetterm\product\11.1.0\db_1\BIN>sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Mi Okt 21 09:18:16 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

SQL> connect / as sysdba
Connect durchgef³hrt.
SQL> connect / as sysdba
SQL> alter user hr identified by hr account unlock;

http://oracle.com

Variablen binden

http://www.oracle.com/technology/pub/articles/oracle_php_cookbook/ullman_bindings.html

http://www.akadia.com/services/ora_bind_variables.html

verbundene Benutzer

select * from V$session;

user privileges

materialized views

last testen

expdp

flashback version query