Tablespace transport in Oracle 9.2.0.1.0

[skdas]

Whether any one has faced the following problem..?

1)During import It gives the following error(warning).

IMP-00058: ORACLE error 1460 encountered
ORA-01460: unimplemented or unreasonable conversion requested

2)The document says, the Function based index does not get transported. But in Oracle 9i(9.2.0.1.0 ), I see it gets transported.

Any dea..?

[SANJAY_G]

There are few conditions for transportable tablespace..

- The source and target database must be on same hardware platform and OS.

- The source and target database must use the same character set and and national character set.

- FBI is not supported by TT (even in 9.2)

HTH

[skdas]

- The source and target database must use the same character set and and national character set.

How to know character set and national character set of a database..?

[Orca777]

Hi,
use V$NLS_PARAMETERS

Orca