Home » SQL & PL/SQL » SQL & PL/SQL » It's stoped while a table was creating. (oracle 10.2.0 RHEL5)
It's stoped while a table was creating. [message #334226] Tue, 15 July 2008 23:04 Go to next message
crazyzhou
Messages: 38
Registered: March 2008
Location: china
Member
when I create a table from remote database, it has more than 10,000,000 records, and the tablespace temp_cdr belong to is NOLOGGING , SQL statement is:
create table temp_cdr as
select * from cdr_200807@db1

the rowcount of the temp_cdr is stoped. what's wrong?
Re: It's stoped while a table was creating. [message #334229 is a reply to message #334226] Tue, 15 July 2008 23:16 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated above

>what's wrong?
Something broke.

You post no details.
You get no useful response.
Re: It's stoped while a table was creating. [message #334232 is a reply to message #334226] Tue, 15 July 2008 23:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
the rowcount of the temp_cdr is stoped.

What do you mean? What did you do that lead you to this conclusion?

Regards
Michel
Re: It's stoped while a table was creating. [message #334248 is a reply to message #334226] Tue, 15 July 2008 23:59 Go to previous message
wangfans
Messages: 7
Registered: July 2008
Location: PRC
Junior Member

please give us the error messages
Previous Topic: plsql routines expose as native web services in 11g
Next Topic: Process very slow while retrieving large amount of data.....
Goto Forum:
  


Current Time: Sat Dec 03 09:47:18 CST 2016

Total time taken to generate the page: 0.07181 seconds