topic Error while creating Table.. in Application Development and Automation Discussions

Error while creating Table..

Former Member — Thu, 19 Jun 2008 07:31:48 GMT

Hi All,

We are try to create table that table already exist in database.

so firstly i delete that table and then create it again.

While creating the table getting the following error.

Table <Table name> could not be acttivated

"Error adjusting the database".

"Error code 8"

I tried to create table in se14 too but all buttons are inactive in the txn.

Any suggestions welcome,

Regards,

Re: Error while creating Table..

Former Member — Thu, 19 Jun 2008 07:34:14 GMT

Hi Navdeep,

Check the Technical Setting of the data base table.. I am sure some problem in the technical setting.

Please see the button "Technical Setting" on the top

&**********Reward Point if helpful*********&

Re: Error while creating Table..

Former Member — Thu, 19 Jun 2008 07:40:11 GMT

hi navdeep..

i think u have to adjust the database utility for that table

utility->database object -> database utility

Re: Error while creating Table..

Former Member — Thu, 19 Jun 2008 07:40:21 GMT

Thanks for prompt reply,

Technical setting were as follows :

Data Class - APPO

Size Category - 1

Buffering not allowed.

Regards,

Re: Error while creating Table..

Former Member — Thu, 19 Jun 2008 07:44:03 GMT

I checked too also but not succed

Re: Error while creating Table..

Former Member — Thu, 19 Jun 2008 07:46:43 GMT

hiii

Please check that you have activated all data elements & domains..because this type of error will come if we hav not activated domains.so check & then activate table at last.

i hope it will solve your problem.

reward if useful

thx

twinkal

Re: Error while creating Table..

Former Member — Thu, 19 Jun 2008 07:47:34 GMT

787657

---

Symptom

The following errors occur when you activate transfer rules:

DT007: Table <techn PSA name>, error during creation in DB.

DT030: Table <techn PSA name> must be created in the DB.

The database issues the following error message:

ORA-00922: Missing or invalid option.

Other terms

DT 007 030 007(DT) 030(DT) ORA 00922 922 922(ORA) 00922(ORA)

Reason and Prerequisites

This is a program error.

The error occurs when you create partitioned PSA tables under ORACLE.

Solution

The error is corrected with the latest version of note 777442. Implement the advance correction of the note.

---

513758

Symptom

Activating the transfer rules terminates with an error message indicating that the activation of the structure & failed in the dictionary.Entries such as the following appear in the log:

The SQL statement was not executed (Error GT 236)

Table & (Error adjusting the database) (Error DT 007)

Table & must be created in the database (Error DT 030)

Table & did not activate (Error DO 408)

You can reach the error number in the activation log by double-clicking on the relevant log row.

Other terms

PSA, RSTSODS, transport, ISTS, ISMP, partitioning, partition, RSAR 695, RSAR695, 695(RSAR), DT007, DT030, GT236, DO408

DT 007, DT 030, GT 236, DO 408

Solution

If the problem occurs in connection with the after import method during the transport of metadata objects, you should first try to activate the transfer rules using RSA1.

Consider the messages in the activation log DDIC.Refer to the messages in the DDIC activation log. Call the log system (SM21) and search for entries for the 'RSA1' transaction code (Tcod).In the SAP note system, search for corresponding keywords, for example, for Oracle messages, search for 'ORA' AND '439' (see related notes also).

If you cannot find a solution for your problem, contact the SAP hotline.

777442

Symptom

Syntactically incorrect statements are created for partitioned tables; the table space for the last partition is missing.

Reason and Prerequisites

This is caused by a program error in the SDB2FORA report.

You are using Basis 620 Support Package 44 or Basis 640 Support Package 5 and Support Package 9.

Implement Note 787848 if you are already using Basis 620 Support Package 45.

Solution

Implement the attached corrections.

The problem will be corrected in the next Support Package.

Re: Error while creating Table..

Former Member — Thu, 19 Jun 2008 09:04:37 GMT

Hi all,

There is table name Ztable and i copied that table to Ztable_bkp and then delete the table ZTABLE after successful deletion now i try to restore the Ztable_bkp to ztable .

When deleting the table Ztable we too delete the request no corresponding to that table.

Now i again copied that ZTABLE_BKP to ZTABLE but it displays the same error as i mentioned in above posts.

When i activate the table ZTABLE_BKP it successfully activated and no error displays.

But When ZTABLE then it displays the error message .

Regards,