No question at this time
DBA Top 10
1 M. Cadot 10900
2 B. Vroman 6700
3 A. Kavsek 5100
4 J. Schnackenberg 3200
5 P. Wisse 3100
6 J. Péran 2200
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
8 D. Dave 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48581
Total active users1393
Act. users last 24h5
Act. users last hour0
Registered user hits last week165
Registered user hits last month388
Go up

A question about datapump
Next thread: Interview question (Background process in Multitenant database)
Prev thread: A question about datapump

Message Score Author Date
Hi everyone, So I hope everyone is healthy a...... Joël Péran Nov 25, 2020, 16:43
I think the french president is responsible for th...... Balaji M Nov 27, 2020, 06:49

Follow up by mail Click here


Subject: A question about datapump
Author: Joël Péran, France
Date: Nov 25, 2020, 16:43, 96 days ago
Os info: Windows 2012 R2 EE
Oracle info: 12.1.0.2 and 19C
Message: Hi everyone,

So I hope everyone is healthy and safe, working at home as I do ;-)
I have imported data from a production database to a new test database with Datapump. There were many schemas involved, and users without schemas as well, and one profile and some roles.
I did not want to use the full export parameter (but maybe I should have) and as a result of my import, I had a lot of small errors dealing with :
- the profile (the profile was not imported so the user based on this profile was not created
- thus the objects of this user were not created as well
- many packages and procedures were not compiled due to lack of rights on "dba" objects (ex: dbms_lock package, v$session view ...)
So my question is simple : do I have to do a full import and just include the schemas I need to and excluding all sys / sysaux schemas ? Do you have tricks to include profiles and roles (roles were not created neither) with the export command ?
And another one :) Some objects where created by mistake on the prod database (a pity) in SYS tablespace. If I use the parameter TABLESPACE to include the tablespaces needed, and if I use a remap_tablespace command, will all my objects be imported even those who were wrongly created ?
Regards,
Joel
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: A question about datapump
Author: Balaji M, India
Date: Nov 27, 2020, 06:49, 94 days ago
Message: I think the french president is responsible for that. According to french people,
he is responsible for everything. So why not him being responsible for that. :):)
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here