| importing dump [message #468491] |
Fri, 30 July 2010 04:58  |
soft_doctor
Messages: 33
Registered: May 2010
|
Member |
|
|
Hi All,
I have a small issue.
We have taken the backup of the database user c57001
which is assigned to the tablespace DEV56 and named the
dump named as "user_dev56.dmp". We want to import this
dump into another user c57002 which has assigned to the
tablespace DEV57.
While importing it is getting import into dev56 tablespace only.
But database user is assigned to dev57 and i want to import data
into the tablespace dev57. Please suggest how to proceed.
Thanks & Regards,
Chandu
|
|
|
|
|
|
| Re: importing dump [message #468517 is a reply to message #468500] |
Fri, 30 July 2010 08:34  |
soft_doctor
Messages: 33
Registered: May 2010
|
Member |
|
|
Hi,
I have revoked the resource privilege.
Now am getting the below error.
Export file created by EXPORT:V09.02.00 via direct path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
IMP-00017: following statement failed with ORACLE error 1950:
"CREATE TABLE "ACCOUNTING_AREA_DESCRIPTION" ("ACCTG_AREA" NUMBER(3, 0), "DES"
"CRIPTION" CHAR(20)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE("
"INITIAL 20480 FREELISTS 1 FREELIST GROUPS 1) LOGGING NOC"
"OMPRESS"
IMP-00003: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace
Regards,
Chandu
|
|
|
|
|
|
| Re: importing dump [message #468840 is a reply to message #468522] |
Mon, 02 August 2010 05:16 |
lnkddbz
Messages: 1
Registered: August 2010
Location: US
|
Junior Member |
|
|
well i think while taking backup some file is missing so you cannot performed the operation , if possible please take backup again an do the operation
file recovery software
==
|
|
|
|
|
|
| Re: importing dump [message #468964 is a reply to message #468491] |
Mon, 02 August 2010 12:29 |
 |
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
|
Senior Member |
|
|
soft_doctor wrote on Fri, 30 July 2010 05:58Blah, blah, blah...
We have taken the backup of the database user c57001 which is assigned to the tablespace DEV56 ....
We want to import this dump into another user c57002 which has assigned to the tablespace DEV57.
... Etc...
You have two options:
1) Allow the table to be created in tablespace DEV56 and then move to tablespace DEV57.
2) Pre-create the table in the DEV57 tablespace and import using the IGNORE=Y option.
[Updated on: Mon, 02 August 2010 13:31] by Moderator Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
