Table select show blank [message #669430] |
Sun, 22 April 2018 23:47 |
|
muthukrish104
Messages: 82 Registered: November 2017
|
Member |
|
|
Hi,
We are facing a different issue.
In a single DB server.
1) We have 2 Different Users and 2 Different tablespaces as their default tablespaces.
2) Both of them are having a object called TABLE1, but in their own different default tablespaces.
When they do select * from <tablename>;
They are not able to get any records.
But the below method gives the output.
Select table_name, num_rows from user_tables
where table_name='<name>';
Kindly help us.
Regards
M.krish
|
|
|
Re: Table select show blank [message #669434 is a reply to message #669430] |
Mon, 23 April 2018 00:43 |
John Watson
Messages: 8937 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
You need to show the result of the commands you have given, and the queries. Please be sure to use [code] tags.
And, by the way, I wish you would not say "record" when you mean "row".
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Table select show blank [message #669467 is a reply to message #669464] |
Tue, 24 April 2018 03:18 |
Roachcoach
Messages: 1576 Registered: May 2010 Location: UK
|
Senior Member |
|
|
Or the source table had no rows either. Literally all I'm seeing here is an object has statistical metadata which doesn't agree with the reality of the table. I see that daily, quite literally.
OP needs to show some investigation/evidence/logs if they want any meaningful help
|
|
|
|
Re: Table select show blank [message #669469 is a reply to message #669468] |
Tue, 24 April 2018 04:22 |
John Watson
Messages: 8937 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Since you have not shown the import command you are using, I have no idea if you used the RESUMABLE parameter or have set it for the instance.
Overall, you seem very reluctant to give out information. It makes one inclined to reciprocate accordingly.
|
|
|
|