Experts Exchange Solution brought to you by
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
REPLACE drops the existing table and then creates and loads it from the source. This is not a valid option if the CONTENT parameter is set to DATA_ONLY.
While there were several headline-grabbing ransomware attacks during in 2017, another big threat started appearing at the same time that didn’t get the same coverage – illicit cryptomining.
When you use TRUNCATE or REPLACE, ensure that rows in the affected tables are not targets of any referential constraints.
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
If the schemas have a lot of grants, the import might not get them all depending on who granted them.
If you drop a user, all grants are removed. Depending on the export, you might need to re-grant them. Again, depends on the export.
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.