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’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...
-
On one of our internal WebSphere application server network deployment v7 environments, I hit the following error. The error was: com.ibm....