There is a very good article on moving Oracle data files to be found here: https://docs.oracle.com/cd/B28359_01/server.111/b28310/dfiles005.htm
Unfortunately, it does no include a final step to bring the tablespace back online.
The command is simple:
ALTER TABLESPACE USERS
ONLINE;
So, execute the procedure in the link above, and when finished, make sure you bring your table-space back online.
Wednesday, March 30, 2016
Subscribe to:
Posts (Atom)
DBT-50000 when using DBCA.bat on Windows (Oracle 19.11)
I’ve been having some trouble getting DBCA to run in order to create databases. Thought I’d share it with you, and thus document it for la...
-
Most of what we're going to want to look at when you're having production issues are available through DMV's. If granti...
-
I was not able to find what I considered a good, clear reference for this when I recently encountered it at a customer installation. I fou...
-
I spent a lot of time on this one, and it wasn't clear from examples precisely how the various items should be used together. The form...