Hello world!
Welcome to wordpressHost Sites. This is your first post. Edit or delete it, then start blogging!
Uncategorized
Oracle
Raw material General ORA-01653: unable to extend table <table> by 128 in tablespace EVENTLOG sqlplus> ALTER TABLESPACE EVENTLOG ADD DATAFILE `ORACLE_HOMEDATABASEEVENT.ORA’ SIZE 30M REUSE; SQLplus Commands end with ; > sqlplus <name>/<password> inloggen in de SQL+ omgeving Noot: host string = nummer van de in te loggen database C:/plus33w.exe <name>/<password>@<Oracleserver> inloggen in de SQL+ omgeving
Console
HP console If the systems hangs do not turn off power but: <CTRL>B Enter Console mode CM> TC Transfer Control, force a memory dump to swapspace, then the system reboots. If swap-space and filesystem have sufficient room the memorydump is written to /var/adm/crash. CM> RS ReSet, don’t do this if you need a memorydump. CM>
Ingres
I worked with Ingres on an OpenVMS system. Tables are stored in files. Large tables can be stored in files on several locations. All database meta-data is in the iidbdb database. Table definitions are in .IDX files. Location, storage structure and indexes are in here. isql <dbname> Nice interface to the database. CTRL-L for scrolling
Sybase
For generic SQL see the database mainpage sp_helpdb Show all databases sp_help Show all objects in the current database select name,id,loginame,type from sysobjects where type = ‘U’ Show only the user tables in the currect database bcp <table> out <file> -c -U<user> -P<passwd> -S<engine> Bulk copy out. Copy the data in <table> to <file> as