OraFAQ Forum: Server Administration » Can't view the table that is exported from one to another

Home » RDBMS Server » Server Administration » Can't view the table that is exported from one to another (ORACl2 10 g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can't view the table that is exported from one to another [message #291808]

Sun, 06 January 2008 23:54

premkumar02
Messages: 3
Registered: January 2008
Location: India

Junior Member

hi friends,
It would be pleasing if anyone could tell me how to view a table that is exported from one schema to another schema. Please let me ASAP. thanks in advance

SQL> select * from tab;

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
CUST2 TABLE
PERSON TABLE
BIN$ci9+2ZFcR5SQsRkXtfh1vQ==$0 TABLE

the table name which is exported is showna as BIN$ci9+2ZFcR5SQsRkXtfh1vQ==$0.

thanks&regards,
Prem

[Updated on: Sun, 06 January 2008 23:57]

Report message to a moderator

Re: Can't view the table that is exported from one to another [message #291818 is a reply to message #291808]

Mon, 07 January 2008 00:02

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

It would be pleasing if anyone could tell me how to view a table that is exported from one schema to another schema

What do you mean?
When a table is imported in a new schema it is part of it and has no difference with another one that was directly created in this schema.

Quote:

the table name which is exported is showna as BIN$ci9+2ZFcR5SQsRkXtfh1vQ==$0.

This is a dropped table.
What is your problem?

Regards
Michel

Report message to a moderator

Re: Can't view the table that is exported from one to another [message #291820 is a reply to message #291818]

Mon, 07 January 2008 00:10

premkumar02
Messages: 3
Registered: January 2008
Location: India

Junior Member

no...this is not a droped table. I have exported it from one schema to another. I tried to view the table which i exported . but, it shown as a junk name... now, i wanna view the table, which i exported.

Report message to a moderator

Re: Can't view the table that is exported from one to another [message #291821 is a reply to message #291820]

Mon, 07 January 2008 00:14

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This table name indicates it was a dropped table in the source schema.

Quote:

now, i wanna view the table, which i exported.

What do you mean "view"?
You see it, you are able to give its name.

Regards
Michel

Report message to a moderator

Re: Can't view the table that is exported from one to another [message #291822 is a reply to message #291820]

Mon, 07 January 2008 00:15

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>no...this is not a droped table.

I'm sure it's dropped table. If you have doubt execute the below query.

select * from recyclebin;

In your source schema before exporting execute the below query

purge table "dropped tablename"

after only export and imported to another user.

Babu B

Report message to a moderator

Re: Can't view the table that is exported from one to another [message #291828 is a reply to message #291821]

Mon, 07 January 2008 00:21

premkumar02
Messages: 3
Registered: January 2008
Location: India

Junior Member

yeah..i agree...i executed the query select * from recyclebin.

it showed the table name BIN$ci9+2ZFcR5SQsRkXtfh1vQ==$0. But, where has the actual table gone???? Surprised

it came as 4 rowd exported, when i tried to export. how to see the table, in the exported schema.

Report message to a moderator

Re: Can't view the table that is exported from one to another [message #291832 is a reply to message #291828]

Mon, 07 January 2008 00:27

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>> But, where has the actual table gone???

 select object_name,original_name,type,ts_name,droptime,dropscn from recyclebin;

Babu

Report message to a moderator

Re: Can't view the table that is exported from one to another [message #291852 is a reply to message #291828]

Mon, 07 January 2008 01:28

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

how to see the table, in the exported schema.

Michel Cadot wrote on Mon, 07 January 2008 07:14

Quote:

now, i wanna view the table, which i exported.

What do you mean "view"?
You see it, you are able to give its name.

Don't repeat the same thing, answer the question.
Post what you tried to "view" the table and why it failed. How can we guess what you did?

Regards
Michel

Report message to a moderator

Previous Topic:	Raw Device Vs ASM?
Next Topic:	logminer and dictionary file from another database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 14:14:53 CDT 2024