Go up

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