Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

EXTERNALLY CREATE USER username IDENTIFIED { BY password GLOBALLY AS 'external name' } [ DEFAULT TABLESPACE tablespace) [ TEMPORARY TABLESPACE { tablespace tablespace_group_name } ] [QUOTA { integer...

Q:

Using SQL Developer execute the following queries with these statements. N eed help with the joining clauses in SQL. PLEASE help Write a query to display the title, publisher name, and author FROM...

Q:

Apply in sql and screenshot output// pls correct answer -------------------------------------------------------------------------- Create New Tablespace " create tablespace tabl espace_name datafile...

Q:

EXTERNALLY CREATE USER username IDENTIFIED { BY password GLOBALLY AS 'external name' } [ DEFAULT TABLESPACE tablespace) [ TEMPORARY TABLESPACE { tablespace tablespace_group_name } ] [QUOTA { integer...

Q:

1. (TCO 6) MySQL stores information about system variables in a set of tables that can be queried to get different pieces of data. Which one of the following is the name of the Schema these tables...

Q:

Subject: Oracle DBA 1. Your database has a single undo tablespace, and you decide to add another. How can you ensure that the new one will be used? A. Change the UNDO_TABLESPACE parameter to point to...

Q:

QUESTION 1 Automatic segment space management on th tablespace causes which of the following table attribtes in that tablespace to be ignored? A . The whole storage clause B . NEXT and PCTINCREASE C...

Q:

QUESTION 1 Automatic segment space management on th tablespace causes which of the following table attribtes in that tablespace to be ignored? A . The whole storage clause B . NEXT and PCTINCREASE C...

Q:

Subject: Oracle DBA 1. A table is created with this statement: Create table emp_copy tablespace users as select * from employees; Which of the following changes would make it impossible to drop the...

Q:

Tablespace Creation and Reassignment using SQL PLUS (Oracle) It has been determined that user "SCOTT" should use a new temporary tablespace called TEMP2 size equivalent to TEMP tablespace (refer to...

Q:

We can use the utility-maximizing rule to determine whether consumers are doing the best they can. Suppose a firm has a fixed budget of $200 to spend on punch and cookies for its holiday party. The...

Q:

Refer to the transactions recorded directly in T accounts for We-Go Delivery Service in Exercise 3-13. Assume that all of the transactions took place during December 2010. Prepare a trial balance at...

Q:

A recent study found that companies that paid workers above - average wages saw which impact? Mutiple Choice lower shareholder returns excellent shareholder returns much lower overal growth rediced...

Q:

Fiber - optic cable is to install than coaxial ( television ) cable. just as expensive. more expensive. much less expensive. less expensive.

Q:

=+2. Can you imagine a world without corporations? What would we lose? What would we gain?

Q:

=+1. Make the case for the corporation as a force for good in society today.

Q:

=+3. What are the two main issues with social entrepreneurship? Which do you think is the most dangerous to the case for social entrepreneurship? Why?