I don’t like having to look up the directory name/structure when creating a new datafile.
I don’t even like having to copy and paste it.
So I avoid all of that, by using the CREATE LIKE dialog.
View > DBA
Add a connection.
Find one in the tablespace you want to add space for.
Now just fill in the details, or change things up as needed.
Can’t Figure Out Which Datafile belongs to What Tablespace?
Try this trick. Hopefully your datafiles have some sort of familiar naming standard, but in case they don’t…
People always ask me how long to create a blog post?
In this case, about 10 minutes. And the real part of the post is about 75 words. Does that make this post less than valuable? You tell me.