Today, open the Web, I can't enter the system. WebLogic has been throwing an exception that cannot be opened. I feel very strange, I don't have any data. How can I suddenly can't open it. So I ran to the WebLogic console, put the established data The link is deleted, and the data source setting is also deleted, only confirming is no problem, but it is still unable to enter the system. This is strange. I will re-establish the link pool and data source. After the establishment, after the WebLogic console test is The link is successful, but the web still does not open the database, which cannot be launched. I open the system service, I found that Oracle's 80 monitors have stopped, it is terrible, because I stopped, I had to reload Oracle, I think of a one-piece deletion table information. I decided to go to the network. I just had this information on the Internet. One check, the problem really discovered. Because changed the name of the computer, I suddenly remembered Yesterday, when I shared my own things, I had a similar computer. In order to share the behavior of the rename, I changed back to the original name, restart the computer. Link OK, don't say that the monitor has been reopened.
I didn't want to touch it again in the afternoon. Because I want to import the table to the database, my method is very soil, first turn into text, then import Access, then add a field, as the symbol of the replacement statement, finally output to TXT, at this time The format just can replace my custom $ 2 $ 2 to insert the statement. Because, I have to build a temporary data, because the data of Execl is unregulated, putting the information of several tables Together, I tried to build a TEMP table, strange, and found that it could not be created. I said the space limit of User. I remember that I defined the user's tablespace to the user, but I didn't pay attention to the problem of size limit. Online is a master Many, such a problem is also a lot of people have passed, saying "Table Space Limit", using select * from user_ts_quotas can find the configuration, found, only max_bytes is 0, there is a flaw, in order to consider, I am just to the administrator user Change the tablespace of the current user to unrestricted, return to re-view, not making it intended to become -1, is unrestricted by general meaning.
problem solved!
