Home » RDBMS Server » Server Administration » Can't view the table that is exported from one to another (ORACl2 10 g)
Can't view the table that is exported from one to another [message #291808] Sun, 06 January 2008 23:54 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
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
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
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
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 Go to previous messageGo to next message
babuknb
Messages: 1734
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
icon11.gif  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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
babuknb
Messages: 1734
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
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 Go to previous message
Michel Cadot
Messages: 64121
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

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


Current Time: Wed Dec 07 02:47:01 CST 2016

Total time taken to generate the page: 0.19193 seconds