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.
Subscribe to:
Post Comments (Atom)
Get Restart log using PowerShell
I'm often curious about a restart on a Windows server system. An easy way to get a list of the restart and what initiated it is to use t...
-
Most of what we're going to want to look at when you're having production issues are available through DMV's. If granti...
-
NOTE: These instruction apply to the connections, reports, menus, etc in Oracle SQL Developer. If you are looking to change the font of you...
-
I was a bit surprised that not all RDBMS platforms offer robust, native support for regular expressions. Oracle: Oracle introduced this ...
No comments:
Post a Comment