Updates to the table from the database level.

[Former Member]

Hi Dear All,

If we do some updates to the table at the Database Level, like i deleted some records from the table at the Oracle level. But I'm still able to see the same deleted records from the Data Dictionary(SE11) at the application level.

Can you pl explain the mechanism, that how it is possible and why.

best regards

Mahesh

[Former Member]

Hi Dear All,

If we do some updates to the table at the Database Level, like i deleted some records from the table at the Oracle level. But I'm still able to see the same deleted records from the Data Dictionary(SE11) at the application level.

Can you pl explain the mechanism, that how it is possible and why.

best regards

Mahesh

[Former Member]

hi,

sorry i didnt get about the oracle level.

and the point is we can delete by writing a code delete database table but not advisable.

[Former Member]

transparent tables store data directly....if you delete some data from transparent tables, the same is reflected in the database (oracle) but the reverse is not true...if you modify the database table contents directly...the dictionary table remains intact...

transparent tables have a one-to-one relationship with the database tables....

hope that clarifies a bit....

(somebody correct me if i am horribly wrong)

[Former Member]

Not possible!!!

Else do 1 thng go to the table and go to database table utilty

and then adujst database table

Hope it helps

[Former Member]

Hi,

Thanks for the replies, but my doubt is there still. How can we get the data from the table, eventhough there is no data at the underlying database.

Hi Bhanu,

Even after adjusting database table also, i'm able to see the records

Thanks