This shows you the differences between two versions of the page.
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] 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]] |