-
Hi,
Before I import a full dump file (the export was done by system user) as system user, do I need to know which users I need to create manually in order to import data belonging to those users or the import utility will automatically create necessary users and/or other things?
Thanks,
Jiong
-
if its a full database export oracle will create all the users in the database...if its a schema dump you need to know to which user you want the database to dumped...
regards
anandkl
anandkl
-
Hi anandkl,
So I just create a new database instance, and then import as system user? The import utility knows what should be created and will not give 'users not existed' error?
Thanks,
Jiong
Jiong
---------------------------
OCP (DBA 8, 8i, 9i, AD, iAD)
SCSA, SCJP, SCWCD
---------------------------
-
what exactly u want , u want schema users dump or full database dump.
U can use the parameter show=y in import to see the contents of the export dump file u have .
Eat , Drink & Enjoy life -
pravin_kini@hotmail.com
-
Hi,
I did some test and when importing a full dump file, it doesn't need to create users.
Thanks,
Jiong
-
Are the tablespace name same in the instance where u want to import it.
As long as the tablespace exist full database dump will create the users.
Eat , Drink & Enjoy life -
pravin_kini@hotmail.com
-
A question that sometimes drives me hazy: am I or are the others crazy?
VenDe ChukPeen Zuri
Someone who quotes himself as a DBA and posts simple question in forums is a big idiot to me . I donot care what others think
-
Jiong, Could you please paste your imp command. Full import should create all the users in dmp file.
And vendechukp, please refrain from distracting the main discussion.
-- Dilip
-
Hi Dilip,
Below is how the import is going:
$ imp
Import: Release 8.1.6.0.0 - Production on Wed Jul 3 11:40:25 2002
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Username:
Password:
Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Import file: expdat.dmp > data_c.dmp
Enter insert buffer size (minimum is 8192) 30720>
Export file created by EXPORT:V08.01.06 via direct path
Warning: the objects were exported by SYSTEM, not by you
import done in US7ASCII character set and US7ASCII NCHAR character set
List contents of import file only (yes/no): no >
Ignore create error due to object existence (yes/no): no >
Import grants (yes/no): yes >
Import table data (yes/no): yes >
Import entire export file (yes/no): no >
Username:
Enter table(T) or partition(T:P) names. Null list means all tables for user
Enter table(T) or partition(T:P) name or . if done:
. . importing table
.
.
.
.
.
.
IMP-00009: abnormal end of export file
IMP-00028: partial import of previous table rolled back: 1835351 rows rolled bac
k
Import terminated successfully with warnings
Also, I checked the alert.log file under bdump and found the following error:
ARC0: media recovery disabled
Thread 1 cannot allocate new log, sequence xxx
Checkpoint not complete
Is this something with archivelog mode? I checked the instance and it has ARCHIVE started. However, under the directory where the archivelog files are supposed to store, there is no file there.
Anyway, I am still investigating this. I would appreciate any opinion or suggestion from you.
Jiong
-
yes when it says that whether u want to import the entire export file u have said NO.
Then secondly when u said NO for the entire export file u it asked u username there also u have kept it blank.
Thirdly when it prompted for table , u should have entered table names. There also u have put it blank.
If u want to import the entire dump u should say YES in the parameter import entire file.
As i said ealier that as long u have tablespaces created in your new instance a full import will create users fro u.
Eat , Drink & Enjoy life -
pravin_kini@hotmail.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|