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
Next revision Both sides next revision
kurs:oracle-admin [2009/11/05 09:41]
mh
kurs:oracle-admin [2012/09/25 17:22]
127.0.0.1 external edit
Line 1: Line 1:
 +[[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;
 +
 +[[materialized views]]
kurs/oracle-admin.txt · Last modified: 2021/10/06 13:41 by admin