After you login to the shell
type su - oracle and hist enter
type the Exp/Imp query
to open sql plus
type su - oracle
Showing posts with label database. Show all posts
Showing posts with label database. Show all posts
Saturday, 21 May 2016
Tuesday, 24 February 2015
Connect Java Application to Oracle Server
Use the following connection string to connect Java Applications to Oracle Database Serve
User Name: un
Password: p/w
jdbc:oracle:thin:@IP_Address_or_DomainName:1521:ora11g
Oracle Mapbuilder Example:
User Name: un
Password: p/w
jdbc:oracle:thin:@IP_Address_or_DomainName:1521:ora11g
Oracle Mapbuilder Example:
Sunday, 25 November 2012
the setup routines for the sql server odbc driver could not be found
error "the setup routines for the sql server odbc driver could not be found. please reinstall the driver"
error: "data source name not found and no default driver specified"
The Magic solution is
windows start>run>regsvr32 odbcconf.dll
everything will be OK In sha' Allah
error: "data source name not found and no default driver specified"
The Magic solution is
windows start>run>regsvr32 odbcconf.dll
everything will be OK In sha' Allah
Wednesday, 29 August 2012
Backup MSSQL Database from Command Prompt
Start the command prompt and type the following:
C:\Users\Administrator>sqlcmd -E -Q "backup database databaseName to disk='C:\backups\ databaseName.bak' with format" > "C:\backups\backUpLog.log"
The text which hi-lighted by green color it is the cmd default
Hint: with format is used to delete the previous backup and create new one, if you want the current backup to be pushed to the previous one just don't type-write- it.
You can backup more than one database in the same command like the following
"backup database databaseName to disk='C:\backups\ databaseName.bak' with format backup database databaseName to disk='C:\backups\ databaseName.bak' with format" and so on
Backup using Batch file:
You can Create sql query file like"backupDBs.sql" and type in it
backup database databaseName to disk='C:\backups\ databaseName.bak' with format
and call it to be executed from batch file which contains the following command
sqlcmd -s . -i "C:\backupDBs .sql" > "C:\backupDBLog.log"
and you can Schedule it as you want via Scheduled Tasks
or you can place sqlcmd -E -Q "backup database databaseName to disk='C:\backups\ databaseName.bak' with format" > "C:\backups\backUpLog.log" in the batch file
1- Navigate to Control Panel, Scheduled Tasks, Add New Task, and select Command Prompt
2- Change the task path to backupdb.bat, start path to C:\ and set how often you want to backup
Mohammad Abu Hmead
C:\Users\Administrator>sqlcmd -E -Q "backup database databaseName to disk='C:\backups\ databaseName.bak' with format" > "C:\backups\backUpLog.log"
The text which hi-lighted by green color it is the cmd default
Hint: with format is used to delete the previous backup and create new one, if you want the current backup to be pushed to the previous one just don't type-write- it.
You can backup more than one database in the same command like the following
"backup database databaseName to disk='C:\backups\ databaseName.bak' with format backup database databaseName to disk='C:\backups\ databaseName.bak' with format" and so on
Backup using Batch file:
You can Create sql query file like"backupDBs.sql" and type in it
backup database databaseName to disk='C:\backups\ databaseName.bak' with format
and call it to be executed from batch file which contains the following command
sqlcmd -s . -i "C:\backupDBs .sql" > "C:\backupDBLog.log"
and you can Schedule it as you want via Scheduled Tasks
or you can place sqlcmd -E -Q "backup database databaseName to disk='C:\backups\ databaseName.bak' with format" > "C:\backups\backUpLog.log" in the batch file
1- Navigate to Control Panel, Scheduled Tasks, Add New Task, and select Command Prompt
2- Change the task path to backupdb.bat, start path to C:\ and set how often you want to backup
Mohammad Abu Hmead
Subscribe to:
Posts (Atom)