| Author | Message | ||
     Airliner Junior Artist Username: Airliner Post Number: 454 Registered: 11-2011 Posted From: 136.223.19.52 Rating: N/A |
DB links owned by that schema user should come over "as it is". As long as your QA DB link is same, the imported DB link owned by schemaX (from DEV A schemaX imported into DEV B SchemaY) should work. Great minds discuss ideas. Average minds discuss events. Small minds discuss people. | ||
| Dma Side Hero Username: Dma Post Number: 4914 Registered: 11-2009 Posted From: 70.176.202.116 Rating: N/A |
If it is done by other DBA, you have to be very specific. Here is a process that can be very clean. - create new schemas, users and roles keep empty db ready. - create the dump including grants - import the db including grants | ||
| Airliner Junior Artist Username: Airliner Post Number: 452 Registered: 11-2011 Posted From: 136.223.19.52 Rating: N/A |
DB links owned by that schema user should come over. Great minds discuss ideas. Average minds discuss events. Small minds discuss people. | ||
| Sensexxxxx Side Hero Username: Sensexxxxx Post Number: 5723 Registered: 08-2011 Posted From: 171.159.64.10 Rating: N/A |
what about DB link objects? scenario is say..we have db links from DEV db to QA db....if i want to retain these db links in the new DEV db to the new QA db...whats the process? | ||
| Sensexxxxx Side Hero Username: Sensexxxxx Post Number: 5722 Registered: 08-2011 Posted From: 171.159.64.10 Rating: N/A |
i am not the one who does this? DBA will do....but vallu roles, dblinks gurinchi edo cheppi...I have to recrate them annaru..so checking if get exported or not in the dump ani? they clearly said they gonna create dump and give to the other DBA and he will imposrt the dump in the enw server.... old server is 10g and the new one is 11g... i am documenting this process with the steps invloved...so need this info... | ||
| Airliner Junior Artist Username: Airliner Post Number: 450 Registered: 11-2011 Posted From: 136.223.19.52 Rating: N/A |
If you have taken export dump using FULL = Y, create new schema on target database and use datapump remap_schema. Grants/roles should come over with the datapump import remap_schema. If you want to export only a specific schema to a dump file, make sure you include "INCLUDE GRANTS ..." in your expdp command. More detail on datapump INCLUDE/EXCLUDE go here: expdp/impdp help=Y or tahiti.oracle.com and search for expdp/impdp include/exclude. Finally oracle did good job with tahiti.oracle.com (one place doc center) Great minds discuss ideas. Average minds discuss events. Small minds discuss people. | ||
| Dma Side Hero Username: Dma Post Number: 4907 Registered: 11-2009 Posted From: 70.176.202.116 Rating: N/A |
What is the source db and dest db versions? if it is 10g or 11g, are you using imp or dmp? there are different options on the command line to drive this. you can just give as simple command as dump all or you can get specific. | ||
| Sri_anji Side Hero Username: Sri_anji Post Number: 8577 Registered: 02-2008 Posted From: 63.66.34.226 Rating: N/A |
10G? cbn ntr same family.. adhikaram mama ki poyinaa alludu ki vachindhi....we are fine --- OT http://www.youtube.com/watch?v=ZmnFXHU2dqo -- Daivam | ||
| Sensexxxxx Side Hero Username: Sensexxxxx Post Number: 5721 Registered: 08-2011 Posted From: 171.161.160.10 Rating: N/A |
need to export one schema from my oracle database and export it to another server... DB dump create chesthe.....will the roles, users, db links...ivi kuda export avuthaya....? or do i have take recreate them after importing the dump in the new server? also are there any key issues that I need to take care of while doing this? |
