As a database administrator (DBA), you will need to backup your datafiles on reg

Question

As a database administrator (DBA), you will need to backup your datafiles on regular basis. Thus, it is important for you to know which datafile is used to store certain tables.

How do you find out which tablespace is used for table "salesreps?"

How do you find out which datafile is used to store data for the above tablespace?

Please check the data below

CREATE TABLE ITEMS
(O_ID NUMBER(38)
,ID NUMBER(38)
,P_ID NUMBER(38) NOT NULL
,QUANTITY NUMBER(38) DEFAULT 1 NOT NULL
);
*/

CREATE TABLE PARTS
(ID NUMBER(38)
,DESCRIPTION VARCHAR2(250) NOT NULL
,UNITPRICE NUMBER NOT NULL
,ONHAND NUMBER(38) NOT NULL
,REORDER VARCHAR2(40) NOT NULL
);

CREATE TABLE SALESREPS
(ID NUMBER(38)
,LASTNAME VARCHAR2(100) NOT NULL
,FIRSTNAME VARCHAR2(50) NOT NULL
,COMMISSION NUMBER(38) NOT NULL
);

ALTER TABLE PARTS
ADD CONSTRAINT P_ID PRIMARY KEY
(ID) ;

ALTER TABLE SALESREPS
ADD CONSTRAINT S_ID PRIMARY KEY
(ID) ;

ALTER TABLE PARTS
ADD CONSTRAINT PAR_DESCRIPTION UNIQUE
(DESCRIPTION) ;

-- PARTS

INSERT INTO parts
VALUES (1,'Fax Machine',299,277,50);
INSERT INTO parts
VALUES (2,'Copy Machine',4895,143,25);
INSERT INTO parts
VALUES (3,'Laptop PC',2100,7631,1000);
INSERT INTO parts
VALUES (4,'Desktop PC',1200,5903,1000);
INSERT INTO parts
VALUES (5,'Scanner',99,490,200);
COMMIT;

-- SALESREPS
INSERT INTO salesreps
VALUES (1,'Pratt','Nick',5);
INSERT INTO salesreps
VALUES (2,'Jonah','Suzanne',5);
INSERT INTO salesreps
VALUES (3,'Greenberg','Bara',5);
COMMIT;

WHENEVER SQLERROR CONTINUE;

-- column formatting here
CLEAR COLUMNS;
COLUMN file_name FORMAT a40;
COLUMN segment FORMAT a7;
COLUMN tablespace FORMAT a10;
COLUMN auto FORMAT a4;
COLUMN value FORMAT a40;
COLUMN segment_name FORMAT a15;
COLUMN description FORMAT a15;
COLUMN status FORMAT a7;
COLUMN name FORMAT a13;
SET PAGESIZE 30;

SET SERVEROUTPUT ON;

CLEAR SCREEN

PROMPT Script successfully completed.
PROMPT
PAUSE Press RETURN to continue.

CLEAR SCREEN

PROMPT BEGIN PRACTICING NOW!
PROMPT
PROMPT You are now ready to begin practicing the excercises in
PROMPT Chapter &chapter : &title
PROMPT
PAUSE Press RETURN to continue.

CLEAR SCREEN

Explanation / Answer

1. We will have the tablespace information in the user_table for each table in the database.

Ro know the table space for the table we nees to run

2. To know the information of datafile of tablespaces it will be srored in v_datafile.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.