Yeah thats what im looking for. Only prob is i get an error:

Using Toad For Oracle Ver 8.6

ORA-31603: object "Testertable" of type TABLE not found in schema "MNP"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 2857
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3192
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4078
ORA-06512: at "SYS.DBMS_METADATA", line 326
ORA-06512: at "SYS.DBMS_METADATA", line 410
ORA-06512: at "SYS.DBMS_METADATA", line 449
ORA-06512: at "SYS.DBMS_METADATA", line 615
ORA-06512: at "SYS.DBMS_METADATA", line 1221
ORA-06512: at line 1

There is a table called Testertable and it is included in the list under schema MNP when i check under the Schema browser? Also tried with other tables.

Tried:

SELECT dbms_metadata.get_ddl('TABLE', 'TesterTable', 'MNP') From DUAL

also tried:

SELECT dbms_metadata.get_ddl('TABLE', 'TesterTable', User) from DUAL

?