Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can i move full dbf tablespace Users from oradata/orcl to another path ? Ora-01653

1905130Feb 8 2016 — edited Feb 10 2016

Good Afternoon from Mexico;

I have a question about .dbf files called tablespace Users.

When in Warehouse Builder appear the error Ora-01653 referent to extend a tablespace in this case Users i need to create from SQL Developer an DBF File saved in C:\app\Administrador\oradata\orcl from this Tablespace and the problem is succeeded.

But actually i have 60 Gb size in my server HD and i need  move the current dbf files ( USERS01.DBF to USERS10.DBF ) to another location ( E: an slave drive ) and create if is possible in this new path DBF Files that i will need in future.

I want to kwon the procedure to be performed, I know how i can access or the procedure to change the path of the DBF files that are generated from tablespace Users.

Regards!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 9 2016
Added on Feb 8 2016
6 comments
1,477 views