New answers tagged

0

$SQLPLUS -S username/password@ip:port/servicename<< EOF SQL-STATEMENTS set sqlbl on commit EOF


0

That is just the paging in SQL*Plus. By default the paging value is 14, that includes a blank line at the start of each page, the line with column headers, the line with heading separators (hyphens) and the rest (11 rows) is for user data. If you increase the pagesize, the result of your query will fit in to 1 page: set pagesize 20 It has nothing to do ...


1

Looks like your oracle directory doesn't exists. You will need to log into the database, create a directory, and retry your import export ORACLE_HOME=/path/to/oracle/home export ORACLE_SID=YOUR_SID sqlplus / as sysdba create directory DUMPS as '/path/to/your/dump/files'; exit; And retry your import. Pending on the user you are using to do the import, ...


0

It is very recommendable to do a dump in another media of all your database before trying anything else, because your filesystem is probably not going well. You will need to restart the server and run fsck not only because of that file is corrupted, but because the risk of more data corruption, then try to run sqlplus again, if it does not help, you will ...


2

In SQL*Plus, you can change the pagesize SQL> set pagesize 100 will repeat the headings every 100 rows rather than every 15. You can set the pagesize value to (just about) whatever you'd like. If you want to ensure that the headers are only written once, you can set it to a number much greater than the number of rows that the query will return.


1

The first query you have used returns Cartesian product of the rows from these three tables. For details: Join The following is the simple example to join three tables. SQL> select * from student; STUDENT_ID FIRSTNAME LASTNAME ---------- -------------------- -------------------- 1 Will Smith SQL> select * from module; ...


-2

Set the owner of Oracle services to be the domain admin account.



Top 50 recent answers are included