Oracle Database Tutorial 57: IMPDP (REMAP_SCHEMA) how to import table in different user/schema

Key Takeaways

what's up I'm man from ral.com and I'm back with another short and casel tutorial a little while ago someone from you asked me about how to import tables in a different schema than the one from which the table was imported so today in this tutorial I'm going to show you how you can perform a table Import in a different schema but first a brief intro of a schema a schema is a collection of logical structure of data and database objects such as tables indexes and synonyms etc etc article comes with some pre-installed sample schemas such as HR and esot and schema has same name as that of the user so if you find me using words schema and user interchangeably then please don't get confused so let's start the tutorial in the previous tutorial I demonstrated you how to import tables into the schema from which they were exported for this demonstration I used table superheroes which belongs to the schema HR or user HR and I imported this table using the same user HR which means I imported it into the same schema but today I have created a schema or say user by the name of Manish and I will import the table superheroes which belongs to schema HR into this this schema or user Manish first let's log on to the database using this schema Manish and see how many tables does it have okay we are logged in now let's check the user user is Manish let's check whether this user Manish has any tables or not no rules selected which indicates that this user Manish does not have any tables in it now let's import the table superheroes using user Manish or say schema Manish but first we need to come out of the equal prompt let me also clear the screen okay now let's perform our import let's take a look at this command till the parameter tables command is similar to the command that we performed in the last tutorial with where we imported the table in the same schema but here we have an extra parameter which we have to specify when we import tables in different schema which is remap uncore schema this parameter takes two Value First is the old schema or user of the table and second is the new schema or user of the table both are separated by columns although there are several significance of the remap schema parameter but here especially it's resolving the ownership of the table which means this parameter is telling your database that the table superheroes is imported from user HR to user Manish thus adding user Manish as its new honor and transferring all its data and metadata to user Manish and also the user logins as this time we are importing superheroes table using user Manish thus here we have specified the login credential of the user Manish there are few things which must be taken care of such as specify the name of the table with the schema name as I did here all in caps and enclosed in the single codes second always try to write the schema name in all caps although it's not mandatory but sometime not doing so may cause error so it's just a small precaution in order to avoid unnecessary errors now let's get back to our Command Prompt and execute the command import is successful let's again log on to the database using user Manish and see whether we have the table superheroes in it or not let me clear the screen for you let me quickly show you the user first user is Manish now let's check whether we have the table superheroes in it or not here is our table now let's also check the data of this table okay here is our data which means we have successfully imported the table superheroes from user or say schema HR to schema Manish please do visit my blog as there you can also learn about how you can switch the table spaces of the table you can even find all the commands which I have performed here along with the in-depth knowledge of the concept that's it for today hope you will find this video a successful answer of your question and helpful please comment and tweet your feedback and tell me how you likeed my video also please hit the like button and share this video and don't forget to subscribe we'll be back soon with another video till then take care this is Manish from Rebellion rer