kurs:exp_-_imp
Differences
This shows you the differences between two versions of the page.
| — |
kurs:exp_-_imp [2014/09/10 21:22] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | nach | ||
| + | |||
| + | C:\app\<username>\product\11.1.0\db_1\BIN | ||
| + | |||
| + | gehen | ||
| + | |||
| + | > exp hr/hr | ||
| + | alle Fragen mit return quittieren | ||
| + | |||
| + | im sqlplus neuen user anlegen | ||
| + | SQL> create user hrnew identified by hrnew; | ||
| + | Benutzer wurde erstellt. | ||
| + | SQL> grant connect, resource to hrnew; | ||
| + | Benutzerzugriff (Grant) wurde erteilt. | ||
| + | |||
| + | [[alle notwendigen rechte fuer hr]] | ||
| + | |||
| + | (Benutzer löschen) | ||
| + | SQL> drop user hrnew cascade; | ||
| + | |||
| + | > imp system/wifi fromuser=hr touser=hrnew EXPDAT.DMP | ||
kurs/exp_-_imp.txt · Last modified: 2014/09/10 21:22 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
