Linux Error: 2: No such file or directoryĢ. drop tablespace x including contents and datafiles this prevents the need to use OS commands to drop the datafiles from the filesystem and is a bit more secure than using OS commands deleting the unneeded files since manually, a typo is easier done than fixed. ORA-19502: write error on file "/usr/lib/oracle/xe/oradat a/XE/TMPDA T.dbf", īut when i tried this command: CREATE TABLESPACE "TMPDAT" LOGGING DATAFILE '/usr/lib/oracle/xe/oradat a/XE/TMPDA T.dbf' SIZE 1024M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO. how to add an oracle user so that i can run sql loader in this way:Īppreciate if you can provide me the steps. when i login as an oracle user, i am not able to do sqlplus.ġ. I noticed that during the oracle installation, another user called oracle has been created and i has enabled it through "users and groups" GUI. When i log in as a gagajanice and open a terminal, i can do "sqlplus sys as sysdba" and then start up the database. When i installed oracle, i installed it under the profile that i setup during the ubuntu installation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |