Some of the problems Oracle encounters

1. Error ORA-30009 when manufacturing data

To schedule a task:

Insert  into Select  from   by rownum<100000

There will be ORA-30009 connect-by error

To modify a task:

Insert  into Select  from xmltable ('1 to 100000')

Use XMLTable to accumulate

2, Tns:no LISTENER

1) under Win, turn on Oracle monitoring

2) under Linux, CD $ORACLE _home/bin and then lsnrctl start monitoring

3. Installation of Oracle version limit

Database\install\oraparam.ini file to find windows=5.1,5.2

Some of the problems Oracle encounters