Re: Import Problems with Oracle 8i - please help..Backup/restore or export/ import ???

From: osy45 <member18536_at_dbforums.com>
Date: Tue, 11 Mar 2003 07:09:11 +0000
Message-ID: <2628238.1047366551_at_dbforums.com>

why not to import only the users which are acutally not included in the database as you had build a new instance from scratch.

exp system/manager_at_sid-SE full=y buffer=4000000 grants=y consistent=y

imp system/manager_at_sid-EE file=expdat.dmp buffer=4000000 fromuser=(usr1,usr2,usr3) touser=(usr1,usr2,usr3)

then the errors should be approcimately 0

--
Posted via http://dbforums.com

Received on Tue Mar 11 2003 - 08:09:11 CET

This message: [ Message body ]
Next message: Nimisha: "Re: Syntax for oracle"
Previous message: Subrahmanyam Arya: "Oracle 8.1.7 Standard to Oracle 8.1.7 Enterprise Upgrade Question"
In reply to: Subrahmanyam Arya: "Import Problems with Oracle 8i - please help..Backup/restore or export/ import ???"
Next in thread: Frank: "Re: Import Problems with Oracle 8i - please help..Backup/restore or export/ import ???"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message