Home » SQL & PL/SQL » SQL & PL/SQL » SQL*PLUS Oracle 10g
SQL*PLUS Oracle 10g [message #386153] Thu, 12 February 2009 21:52 Go to next message
cwilliam912
Messages: 4
Registered: February 2009
Junior Member
My software is Oracle 10g 10.2.0 and system Window XP.

I don't have a clue what I and suppose to be doing here so here is the question:

Create an object table named CH07NEW_ADDRESSES using the CUSTOMER_ADDRESS_TYPE as its object type and with storage in USER_DTAB tablespace. The table needs 10b of storage and room for rows to double in size when they are updated. Do not create the table because it requires a dictionary-managed tablespace.
Re: SQL*PLUS Oracle 10g [message #386156 is a reply to message #386153] Thu, 12 February 2009 22:09 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Please realize that we don't do homework assignments here.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you
Re: SQL*PLUS Oracle 10g [message #386186 is a reply to message #386153] Fri, 13 February 2009 01:18 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Here is a clue.
http://www.java2s.com/Tutorial/Oracle/0620__Object-Oriented/Youcanalsouseanobjecttypetodefineanentiretableandthetableisknownasanobjec ttable.htm

Just make sure you are creating the objects in the said tablespace.

>>Do not create the table because it requires a dictionary-managed tablespace.
Makes no sense without knowing the broader context of the question.
Previous Topic: SQL & PL/sql
Next Topic: Need procedure for deactivation
Goto Forum:
  


Current Time: Fri Dec 02 18:34:46 CST 2016

Total time taken to generate the page: 0.28768 seconds