Home » SQL & PL/SQL » SQL & PL/SQL » I am unable to create a nested table (merged)
icon1.gif  I am unable to create a nested table (merged) [message #329444] Wed, 25 June 2008 07:46 Go to next message
kishorebabu
Messages: 4
Registered: March 2008
Location: chennai
Junior Member
Hi,

I created object i.e PURCHASEORDERHEADER_TYP and another type PURCHASEORDERDETAIL_TABTYP .

Now, I am trying to create the nested table with the above object and type it's giving some error message but this was already created sucessfully in one envinorment with version ( 9.2.0.7.0 ) but same code i copied and compiled in different envinorment with version (10.2.0.3.0) it's failing



ORA-22913: must specify table name for nested table column or attribute

CREATE TABLE EDI850_TMP
(
  PURCHASEORDERHEADER  PURCHASEORDERHEADER_TYP,
  PURCHASEORDERDETAIL  PURCHASEORDERDETAIL_TABTYP DEFAULT "XXQST"."PURCHASEORDERDETAIL_TABTYP"()
)
NESTED TABLE PURCHASEORDERDETAIL STORE AS POD_DTL_TAB1
TABLESPACE XXQST
PCTUSED    40
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          4M
            NEXT             4M
            MINEXTENTS       1
            MAXEXTENTS       2147483645
            PCTINCREASE      0
            FREELISTS        1
            FREELIST GROUPS  1
            BUFFER_POOL      DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
NOMONITORING;


Regards,
Kishor


[Mod-edit: Frank added code-tags to improve readability]

[Updated on: Wed, 25 June 2008 08:28] by Moderator

Report message to a moderator

Re: I am unable to create the nested table [message #329447 is a reply to message #329444] Wed, 25 June 2008 08:15 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guidelines as stated in URL above
Re: I am unable to create the nested table [message #329449 is a reply to message #329444] Wed, 25 June 2008 08:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In your previous topic you have been requested several times to follow the guidelines.
Please do it.
Read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter).
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel
I am unable to create a nested table [message #330418 is a reply to message #329444] Mon, 30 June 2008 02:27 Go to previous messageGo to next message
kishorebabu
Messages: 4
Registered: March 2008
Location: chennai
Junior Member
Hi,

I created object i.e PURCHASEORDERHEADER_TYP and another type PURCHASEORDERDETAIL_TABTYP .

Now, I am trying to create the nested table with the above object and type it's giving some error message but this was already created successfully in one environment with version ( 9.2.0.7) but same code i copied and compiled in different environment with version (10.2.0.3) it's failing



ORA-22913: must specify table name for nested table column or attribute


CREATE table EDI850_TMP
(
PURCHASEORDERHEADER PURCHASEORDERHEADER_TYP,
PURCHASEORDERDETAIL PURCHASEORDERDETAIL_TABTYP DEFAULT "XXQST"."PURCHASEORDERDETAIL_TABTYP"()
)
nested table PURCHASEORDERDETAIL STORE AS POD_DTL_TAB1
tableSPACE XXQST
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 4M
NEXT 4M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
NOMONITORING;
Re: I am unable to create a nested table [message #330420 is a reply to message #330418] Mon, 30 June 2008 02:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You already post this.
You already post it not formatted.
You didn't answer the questions.
Why don't you think you will have more chances now?

Regards
Michel
Re: I am unable to create a nested table [message #330448 is a reply to message #330420] Mon, 30 June 2008 03:35 Go to previous message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Check Tablesapce XXQST exists or not in your server??

Regards,
Rajat Ratewal
Previous Topic: Sysdate is not working
Next Topic: cursor problem
Goto Forum:
  


Current Time: Mon Dec 05 08:55:23 CST 2016

Total time taken to generate the page: 0.13640 seconds