Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Carl.

Asked: January 09, 2016 - 12:03 am UTC

Last updated: January 09, 2016 - 1:12 am UTC

Version: oracle express

Viewed 1000+ times

You Asked

Hi, I hope I am asking this in the right place, if not many apologies.
Basically I have a personal database and am getting a new PC that has a SSD. The DB has 20 tables half of which are written to once a day with permanent data, half are truncated and re-written daily. On my new PC to improve performance I am going to put oracle on the Solid State Drive what I would like to know is there any way I can put the tables that are truncated daily onto another (hard disk) drive?

Thanks in advance

Carl Harrison

and Connor said...

Yes, its easy

Every table belongs in a tablespace.
Every tablespace is a collection of one or more datafiles.

Hence you could do this:

create tablespace FAST_GOOD_STUFF datafile 'd:\this_is_my_ssd\file01.dbf';

create tablespace SLOW_JUNK_STUFF datafile 'e:\this_is_my_spinning_rust\file01.dbf';


create table IMPORTANT_ONE (x int) tablespace FAST_GOOD_STUFF ;

create table CRAPPY_ONE (x int) tablespace SLOW_JUNK_STUFF ;

Hope this helps


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Super

Carl, January 10, 2016 - 1:34 pm UTC

Well fast answer that solves my problem. Thanks
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.