Problem with Import

[NetCohort]

Hello,

I have one question concerning the import command. Is it possbile to import only one Views "test" of one schema "test_schema"? How could I do it?

The imp help=y command shows me that it seems not possible directly. I try it with Oracle 9i.

Thnak you for answering

Best Regards

[PAVB]

No, you can't.
What you can do is import with options SHOW=Y and ROWS=N to a file; view the file and take your DDL from there.

[NetCohort]

Thank you. But to tell the truth, I cannot follow your idea. Could you explain it within one example scenario perhaps?

Thank you

Best Regards

[davey23uk]

what didntyou get, you were give the option to use - what happened when you did them - did you see the file it created?

[gtcol]

As an alternative, get the DDL ('Text' column) for the view from dba_views, add create or replace view phrase, run the same onto the destination database. You have your view !!

HTH,
gtcol

[NetCohort]

Hi,

ok, thanks.. I will try one of these examples.

[NetCohort]

No, you can't.
What you can do is import with options SHOW=Y and ROWS=N to a file; view the file and take your DDL from there.

Ok, what kind of file do you mean?
The view "test" of the schema "test_schema" was deleted. I import one backup with following parfile.ora:

userid=*/*@testdb
fromuser=test_schema
touser=test_schema
show=y
rows=n

Ok, what is happen now? The deleted view is not available within the schema, or anywhere else.

Regards

[PAVB]

what part of "...view the file and take your DDL from there" you didn't get?

what do you see in your log?

[NetCohort]

Ok, allright. After processing the import command I create the view manually. In fact, not very difficult.