-
help with IMP
Why do we get the following error? This import takes place every day and we have not changed it.
We use the imp command.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.02.01 via conventional path
Warning: the objects were exported by LTR, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
. importing LTR's objects into LTRPROD
. . importing table "COMPONENT" 4907 rows imported
. . importing table "COMPONENT_DIFF" 0 rows imported
. . importing table "COMPONENT_PART" 22374 rows imported
. . importing table "COMPONENT_PART_DIFF" 0 rows imported
. . importing table "COMPONENT_RULE" 359 rows imported
. . importing table "COMPONENT_RULE_DIFF" 0 rows imported
. . importing table "TEXT_VALUE_DIFF" 0 rows imported
. . importing table "USER_SIGNATURE" 187 rows imported
IMP-00017: following statement failed with ORACLE error 1031:
"CREATE UNIQUE INDEX "USER_SIGNATURE_PK" ON "USER_SIGNATURE" ("USER_ID" ) P"
"CTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 10485760 FREELISTS 1 FREE"
"LIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "LETTER_INDEX" NOLOGGING"
IMP-00003: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
. . importing table "WORD_DOCUMENT" 307 rows imported
. . importing table "WORD_TABLE" 110 rows imported
. . importing table "WORD_TABLE_HEADING" 472 rows imported
About to enable constraints...
Import terminated successfully with warnings.
-
Do you have a tablespace called 'LETTER_INDEX' on your target database and do you have authority to create objects in it ?
Is this the first time that the source database has had indexes ? and hence the first time that the import has tried to create any ?
-
hey
we run this script everynight and we have no prob with it... but for some reson it failed lastnight
here is the script:
imp $DBUSER/$DBPASS@$DB_INSTANCE \
file=$DUMP_DIR/$LTRDUMPFILE \
fromuser=$SOURCE_LTR_SCHEMA touser=$LTRUSER \
grants=N \
LOG=$DBERR_FILE statistics=none
then
drop user &1 cascade;
-- Create the user
create user &1 identified by &1;
-- Grant the acccess
grant connect,resource, create session, create synonym to &1;
-
Something is wrong, that's for sure.
By the way, your previous post is confusing, it looks like you attempt to Import "then" you drop the user, recreate it and grant privs.
Is your script spooling to a log? Look around the grant privs statement, what is says?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
it is the other way
drop user &1 cascade;
-- Create the user
create user &1 identified by &1;
-- Grant the acccess
grant connect,resource, create session, create synonym to &1;
here is the script:
imp $DBUSER/$DBPASS@$DB_INSTANCE \
file=$DUMP_DIR/$LTRDUMPFILE \
fromuser=$SOURCE_LTR_SCHEMA touser=$LTRUSER \
grants=N \
LOG=$DBERR_FILE statistics=none
and also have a look at this:
vahx0106>$ pwd
/u51/app/hqa/librarian/db
vahx0106>$ ls -l ltr.dmp
-rw-r--r-- 1 hqalibjl hqa 71116800 May 16 09:17 ltr.dmp
How do i proceed from here on............
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
|