How to reorganize table - note 646681

[former_member299080]

Hi,

If I followed note 646681, I would have to export the table, drop the

table, create the table nd then import the table. The note seems to be

clear about export, create and then import of the table, but it does

not talk about how to drop a table. It talks about dropping a table

space. If I want to export one single table and then drop it before I

create the table and import it, how would I go about doing that the SAP

way? Do I need to use the native sql statement "drop table

<table_name>"?

Thanks.

Marco

[lbreddemann · Accepted solution]

> If I want to export one single table and then drop it before I

> create the table and import it, how would I go about doing that the SAP

> way? Do I need to use the native sql statement "drop table

> <table_name>"?

Hi Marco,

yes, that would be the way to do it - even with SAP.

Anyhow, you should make sure to specify the table together with it's owner, so it would be:

DROP TABLE "<OWNER>"."<TABLENAME>";

Make sure to have a good backup before you drop the table.

best regards,

Lars

[jamal_asi · Accepted solution]

What happens if the owner is not specified and the table is dropped?

[fidel_vales · Accepted solution]

> What happens if the owner is not specified and the table is dropped?

Oracle will assume that you are trying to delete a table on the current schema.

If you are connected as SAP<SID>, then it will delete the correct one.

If you have connected as sysdba, then it will fail