0 6

Database Administration05 marksAdding new tablespaces and datafiles

What is tablespace and datafile in oracle? How we can add new tablespace and datafiles in oracle database?

What is tablespace and datafile in oracle? How we can add new tablespace and datafiles in oracle database? [5]

A tablespace is the logical storage unit in an Oracle database. It is a logical grouping of one or more datafiles that stores database objects such as tables, indexes, and other schema objects. Every Oracle database has at least one tablespace called the SYSTEM tablespace. Key points: - Tablespac...

Up nextWhat is privilege? Write commands to create user, grant privilege, revoke privilege and dr