Hi, this is probably (hopefully) an easy one but just wasn't obvious to me when I googled it.
I have a couple of schemas in my database orcl which two websites are running off. But, I would like to be able to create a copy of each so that I can use them for test purposes.
One of them is called MT@ORCL the other is called CTC@ORCL.
How should I go about that exactly? And how would I refresh the data in that schema afterwards?