Where does oracle stores the tables ?

Where does oracle stores the tables created by user? How to take backup of these tables?

Questions by Suchitam

Showing Answers 1 - 6 of 6 Answers


  • Dec 3rd, 2014

Oracle stores the tables as datafiles. You can recover the table using RMAN

  Was this answer useful?  Yes

hari shankar

  • Aug 5th, 2016

Oracle stores the tables in datafile and one datafile is associates with only one tablespace. we can take backup of any table/tables with exp or expdp.

  Was this answer useful?  Yes

kalyan de

  • Jul 9th, 2017

Own tablespace

  Was this answer useful?  Yes

John Brown

  • Sep 26th, 2017

The newly created table is stored in its own tablespace or default tablespace. The backup can be taken by expdp,exp utility and also backup can be taken with help of rman either on disk or tape (as per your rman config)

  Was this answer useful?  Yes

Neha Tiwari

  • Dec 20th, 2017

Oracle stores the tables in default tablespace or you can say datafiles. You can table EXPDP of the table or RMAN backup as well.

  Was this answer useful?  Yes


  • Mar 30th, 2018

The Tables are physically stored into datafiles and logically stored into tablespaces

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions