User Tools

Site Tools


kurs:oracle-admin

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
kurs:oracle-admin [2009/11/05 09:41]
mh
kurs:oracle-admin [2021/10/06 13:41] (current)
admin [Variablen binden]
Line 1: Line 1:
 +[[Installation Oracle Linux]]
  
 +
 +[[created partioned table]]
 +
 +[[exp - imp]]
 +
 +==== Passwörter ändern, accounts öffnen ====
 +
 +<​code>​
 +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;
 +
 +
 +</​code>​
 +
 +[[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]]
 +
 +[[expdb/​impdb schema|expdp]]
 +
 +[[flashback version query]]