Home » RDBMS Server » Server Utilities » importing dump (oracle 9i, aix5.2)
importing dump [message #468491] Fri, 30 July 2010 04:58 Go to next message
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 #468500 is a reply to message #468491] Fri, 30 July 2010 05:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
User c57002 must have resource role granted. Revoke it.
Re: importing dump [message #468517 is a reply to message #468500] Fri, 30 July 2010 08:34 Go to previous messageGo to next message
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 #468522 is a reply to message #468517] Fri, 30 July 2010 09:13 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>ORA-01950: no privileges on tablespace
Tells it all.
The user has no privs or quota on the tablespace where table is being imported.
Re: importing dump [message #468840 is a reply to message #468522] Mon, 02 August 2010 05:16 Go to previous messageGo to next message
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 #468851 is a reply to message #468840] Mon, 02 August 2010 05:24 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
well i think while taking backup some file is missing so you cannot performed the operation

You think wrong, Mahesh Rajendran gave the solution.

Regards
Michel
Re: importing dump [message #468964 is a reply to message #468491] Mon, 02 August 2010 12:29 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 429
Registered: July 2003
Location: WPB, FL
Senior Member
soft_doctor wrote on Fri, 30 July 2010 05:58
Blah, 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

Re: importing dump [message #468970 is a reply to message #468964] Mon, 02 August 2010 13:33 Go to previous message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And a third option: give quota to user DEV57 to its default tablespace and let the import do its job.
Razz

Regards
Michel
Previous Topic: sql loader
Next Topic: Import from 64bit to 32bit
Goto Forum:
  


Current Time: Mon Sep 01 17:52:02 CDT 2014

Total time taken to generate the page: 0.13341 seconds