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
Last revision Both sides next revision
kurs:oracle-admin [2009/11/05 09:41]
mh
kurs:oracle-admin [2021/10/06 11:58]
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]]
kurs/oracle-admin.txt · Last modified: 2021/10/06 13:41 by admin