Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You have a tablespace that was created with this command: CREATE TABLESPACE CUSTOMERSERVICE DATAFILE 'C:tempcust_serv01.dbf' SIZE 50M AUTOEXTEND OFF; Write a SQL script to accomplish
You have a tablespace that was created with this command:
CREATE TABLESPACE CUSTOMERSERVICE
DATAFILE 'C:\temp\cust_serv01.dbf' SIZE 50M
AUTOEXTEND OFF;
Write a SQL script to accomplish these tasks:
a. Add another tile that is identical (except the name) to the original one.
b. Make the first datafile 25Mb in size.
c. Make the second datafile expandable forever.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started