Re: Oracle table in a seperate Disk or tape

Hi Shafeek Khalidh, thanks for writing this:
> Hi, Can I put a particular table in a disk? After that I'm going to load 70
> GB data into that table and I want to take the backup of that table only
> using exp. So How can I ensure that the data for certain tables are going
> into a particular drive.
>
> Thanks
> Shafeek
>

You create the table(s) in one or more tablespaces that only have one or more datafiles on the specific drive.

To take an exp of one table only, use the syntax: exp...tables=<tablename>

-- 
[:%s/Karsten Farrell/Oracle DBA/g]