Re: FULL EXP not create USER while IMP

From: Istiqfar <istiqfar_at_yahoo.com>
Date: Fri, 30 Jun 2000 23:16:38 +0700
Message-Id: <10544.110949@fatcity.com>

This step is optional, just to make sure, that your tablespace is succesfully created. Creation will be failed in case you import into different machine with different directory structure. Failure in tablespace creation will cause failure in user creation if that failed tablespace is the default or temp tablespace of that user(s).

-istiqfar-

On Thu, 29 Jun 2000 13:24:50 -0700, you wrote:

|=20

| Isa,

|=20

| No, you don't need to create the tablespaces manually at all if you are
| using the FULL=3DY full database import.

|=20

| Winnie

|=20
|=20
|=20
|=20
|=20

| Istiqfar <istiqfar_at_yahoo.com> on 06/29/2000 08:29:21 AM

|=20

| Please respond to ORACLE-L_at_fatcity.com

|=20

| To:   Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
| cc:    (bcc: Winnie Liu/HQ/ISC)

|=20

| Subject:  Re: FULL EXP not create USER while IMP

|=20
|=20
|=20
|=20

| Hi Rahul, better you check import log. Usually you *must* create
| all tablespace manually first before full import to make sure that
| statement "create user... default tbs ..." in dmp file was executed
| succesfully in import process.

|=20

| I've tried full import in 8.1.x with no problem.

|=20

| -isa-

|=20

| On Wed, 28 Jun 2000 04:06:15 -0800, you wrote:

|=20

| | List,
| | i exported full from 7.3 and imported FULL=3DY on 8.1.5
| | it created all the tablespaces, but after that it
| | stopped on ALTER SYSTEM SET SCHEMA...
| | saying user does not exist...
| |
| | is there a way to import full with users also created ?

Received on Fri Jun 30 2000 - 11:16:38 CDT