1. Why does 11i have an 8.0.6 and an 8.1.6 ORACLE_HOME?
Release 11i requires an Oracle8i (v8.1.6) database which is installed in the 8.1.6 ORACLE_HOME. The 8.0.6 ORACLE_HOME is required to host several other components of the Release 11i technology stack (such as Developer 6i and WebDB 2.2). The applications run in server partitioned mode, where the code is compiled and linked with the 8.0.6 ORACLE_HOME.
Custom Search
Saturday, March 24, 2007
Saturday, March 17, 2007
Importing Few Users
I was asked by my friends, few times about - the ways to import more than one user in a go...
I would be creating a parfile like this...
userid=expman/expman@amdbu
file=/bkdump/Exp_Bak/exp_amdbu_0311060054.dmp
fromuser=(schema1, schema2, schema3, schema4)
touser=(schema1, schema2, schema3, schema4)
ignore=y
commit=y
buffer=10000000
log=/export/home/oracle/amdbu/imp_schemas.log
feedback=1000000
I would be creating a parfile like this...
userid=expman/expman@amdbu
file=/bkdump/Exp_Bak/exp_amdbu_0311060054.dmp
fromuser=(schema1, schema2, schema3, schema4)
touser=(schema1, schema2, schema3, schema4)
ignore=y
commit=y
buffer=10000000
log=/export/home/oracle/amdbu/imp_schemas.log
feedback=1000000
Labels:
Day to Day DBA
Subscribe to:
Posts (Atom)